title: Combining text and hyperlink in excel
body: <p>I have text in column B and hyperlink in Column C. I need to concatenate these in column D. But the hyperlink disappears on concatenation in Column D. Cannot find anything online. Can someone please help?</p>
  
  <pre><code>B                               C   
  Quaterly Results are here:      https://bloomberg.com   
  
  D
  Quaterly Results are here : https://bloomberg.com
  </code></pre>
  
  <p>I have used the following formulas , none works:</p>
  
  <pre><code>=B2 &amp; "" &amp; HYPERLINK(C2)
  =CONCATENATE(B2,"", HYPERLINK(C2))
  </code></pre>