Forum Discussion
How can I extract URL from hyperlinks?
I have a worksheet where one column contains hyperlinks (like created with =HYPERLINK(link;text)). How can I create a formula extracting link urls from those hyperlinks? I've tried dozen of search qu...
If you are using HYPERLINK formula, even its a complex formula to generate your link address you just need copy the same formula and instead of HYPERLINK(link;text)) you can delete the formula where will remain only the link
from
=HYPERLINK(A1;"Friendly Name"
to
=A1
from
=HYPERLINK(A1;"Friendly Name"
to
=A1