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 queries and carefully read everything found, but couldn't find a way.

excel

Formulas and Functions

27 Replies

Abiola1
MVP
Apr 06, 2020
tachyglossus

Hello,

Right-click a hyperlink.

From the Context menu, choose Edit Hyperlink. Excel displays the Edit Hyperlink dialog box.

Select and copy (Ctrl+C) the entire URL from the Address field of the dialog box.

Press Esc to close the Edit Hyperlink dialog box.

Paste the URL into any cell desired.
- mrbobmac
  Copper Contributor
  Sep 20, 2024
  Abiola1
  
  It is easy to copy and paste a single hyperlink as shown in this reply. But I have a column of more than 400 links (it is a list of articles). I want to copy and paste ALL of the URLs into a new column. One-at-a-time could take me a couple of hours.