Home

How can I extract URL from hyperlinks?

%3CLINGO-SUB%20id%3D%22lingo-sub-1286119%22%20slang%3D%22en-US%22%3EHow%20can%20I%20extract%20URL%20from%20hyperlinks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286119%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20where%20one%20column%20contains%20hyperlinks%20(like%20created%20with%20%3DHYPERLINK(link%3Btext)).%20How%20can%20I%20create%20a%20formula%20extracting%20link%20urls%20from%20those%20hyperlinks%3F%20I've%20tried%20dozen%20of%20search%20queries%20and%20carefully%20read%20everything%20found%2C%20but%20couldn't%20find%20a%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1286119%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1286324%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20extract%20URL%20from%20hyperlinks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F611636%22%20target%3D%22_blank%22%3E%40tachyglossus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ERight-click%20a%20hyperlink.%3C%2FLI%3E%0A%3CLI%3EFrom%20the%20Context%20menu%2C%20choose%20Edit%20Hyperlink.%20Excel%20displays%20the%20Edit%20Hyperlink%20dialog%20box.%3C%2FLI%3E%0A%3CLI%3ESelect%20and%20copy%20(%3CSTRONG%3ECtrl%2BC%3C%2FSTRONG%3E)%20the%20entire%20URL%20from%20the%20Address%20field%20of%20the%20dialog%20box.%3C%2FLI%3E%0A%3CLI%3EPress%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEsc%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20close%20the%20Edit%20Hyperlink%20dialog%20box.%3C%2FLI%3E%0A%3CLI%3EPaste%20the%20URL%20into%20any%20cell%20desired.%3C%2FLI%3E%0A%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1286339%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20extract%20URL%20from%20hyperlinks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F611636%22%20target%3D%22_blank%22%3E%40tachyglossus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20you%20can%20follow%20the%20steps%20in%20the%20link%20below%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fhowtouseexcel.net%2Fhow-to-extract-a-url-from-a-hyperlink-on-excel%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhowtouseexcel.net%2Fhow-to-extract-a-url-from-a-hyperlink-on-excel%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

2 Replies
Highlighted

@tachyglossus 

Hello,

 

  1. Right-click a hyperlink.
  2. From the Context menu, choose Edit Hyperlink. Excel displays the Edit Hyperlink dialog box.
  3. Select and copy (Ctrl+C) the entire URL from the Address field of the dialog box.
  4. Press Esc to close the Edit Hyperlink dialog box.
  5. Paste the URL into any cell desired.
Highlighted