title: Creating URL with formula in excel
body: <p>In my excel sheet I am creating URLs by concatenating the content of various cells.</p>
  <p>The formula in D2 is <code>=CONCATENATE(&quot;http://&quot;,A2,&quot;.&quot;,B2)</code></p>
  <p><a href="https://i.stack.imgur.com/6ddVU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6ddVU.png" alt="enter image description here" /></a></p>
  <p>The problem I have is that the resulting URL is not seen as a hyperlink, and I have to manually copy, paste as value and then configure the hyperlink to make it work.</p>
  <p>Is there a way to let excel recognize it as a URL and make it immediatly clickable?</p>