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...
non-coding way:
- ALT + F9 (to show the hyperlinks)
- file -> options (at the bottom left of the screen) -> advanced -> print field codes instead of their values
- change the page size so the hyperlinks fit in one line (you can replace the word HYPERLINK with nothing to create more space)
- save the file as a PDF
- Copy all/paste into a new word doc.
- remove all the excess beginning and ends with 'replace' (CTRL + F -> small down arrow next to the X or magnification glass -> replace).
- Look for spaces inside the hyperlinks (they might slip in) or links that split into two lines
