title: Combining Text and Hyperlink Into Text that is Hyperlinked
body: <p>I have text in column A and URLs in column B.</p>
  
  <p>I want the merged A&amp;B shown in column C.</p>
  
  <p>Example:</p>
  
  <p>Column A | Column B | Column C<br>
  Product 1 | google_dot_com | Product 1 (with hyperlink to url)<br>
  Product 2 | yahoo_dot_com | Product 2 (with hyperlink to url)<br>
  Product 3 | stackoverflow_dot_com | Product 3 (with hyperlink to url)   </p>
  
  <p>Here is an image. <img src="https://i.imgur.com/KU2QXFD.jpg" alt="http://i.imgur.com/KU2QXFD.jpg"></p>
  
  <p>This is different from just referencing the cells and using the HYPERLINK(A1,B1) and then copying it down column C.</p>
  
  <p>Here is a small test file I created that you can download if my above example wasn't clear enough. <a href="http://www.filedropper.com/stacker-help" rel="nofollow noreferrer">http://www.filedropper.com/stacker-help</a></p>
  
  <p>Using Microsoft Office Professional Plus 2013, Windows 7</p>