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?