Forum Discussion

Copper Contributor

Apr 06, 2020

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jan 01, 2022

tachyglossus

As variant

=LET(
    range,    A1:A2,
    str,      FORMULATEXT( range ),
    start,    FIND( """", str )+1,
    end,      FIND( """", str, start ),
    MID( str, start, end-start )  )

anupambit1797

Iron Contributor

Dec 17, 2023

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

LanserJ
Copper Contributor
May 15, 2024
anupambit1797 @Sergei Baklan
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.