I have a cell with text, and it's hyperlinked
for example the cell A1 has text "MY LINK" and it is linked to "http://mylink.com/"
I want the cell next to it (A2) to show the url
so A2 has "http://mylink.com/"
If I use "=A1" it only shows the text, not the url. And if I use =Hyperlink:A1 or something similar it has the text and the link, but i ONLY want the link
Is there a command like "=A1("url")" or something like that to show the url of the text in that cell?
can someone please reply asap and email me the little piece of code at [email protected]
thanks in advance