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...
tachyglossus I think I found a better way using Flash Fill.
1. If Column A contains the Hyperlink text, click on the first two links (e.g. A1 and A2). Then copy/paste those two URL to notepad. You need this text to get Flash Fill to work.
2. Make a new column in excel for the URL, for example Column B
3. In B1 start typing in the URL from notepad that matches the link in Cell A1. Type the URL exactly as it appears in notepad
4. Once completed, in B2, start typing the next URL from notepad, Excel's Flash Fill will take over and suggest the URLs for all remaining cells.
No formulas, no Macros, No VBA.