Originally Posted by Billy_McSkintos

I would like to create the HTML code for a hyperlink in a cell from the text contents of two other cells. I'm sure you know the HTML but here goes:

HTML Code...

<a href="http://www.google.com"Google</a

...would produce a hyperlink to Google

If the URL (http://www.google.com) is in cell A1
and the name (Google) is in cell A2
I want to populate cell A3 with the EXACT text

<a href="A1"A2</a

where the contents of A1 and A2 are displayed:
<a href="http://www.google.com"Google</a

I hope that makes sense, can you help me?