title: How do I create auto combine URLs in Excel when i input the text?
body: <pre><code>URLs Sample
  A:https://stackoverflow.com/questions/ask?a=""
  B:https://stackoverflow.com/questions/ask?b=""
  C:https://stackoverflow.com/questions/ask?c=""
       A             B            C
  1 AA10002143    BBANZIEC    CC123415
  2 AA21001234    BBCSKAUD    CC123556 
  3 AA11231214    BBKLKFSH    CC134564
  </code></pre>
  
  <p>I need a formula that combines a cell's value and text string that will complete a URL within the <code>HYPERLINK</code> function. I tried the following formula, but it won't work:</p>
  
  <pre><code>=HYPERLINK([https://stackoverflow.com/questions/ask?c="]Sheet1!C1&amp;["],C1)
  </code></pre>
  
  <p>Any help is gladly appreciated.</p>