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...
HiSergeiBaklan , I tried to use this LET function, to extract the URL, but getting #NA, can you please share a sample spreadsheet with this function used?
Thanks in Advance,
Br,
Anupam
the #N/A is caused by FormulaText function if the Hyperlink is set by the Edit Hyperlink editor then there is no formula to extract the text from.