3 Ways to Extract a URL From Hyperlinks in Microsoft Excel

Maria is a Content Writer with a keen interest in Technology and Productivity Tools. Her articles can be found on sites such as Onlinetivity and Delesign. Outside of work, you can find her mini-blogging about her life on social media.

Afam has been a content writer with Guiding Tech Media since August 2023. However, his experience in tech writing dates back to 2018, when he worked as a freelance writer for Make Tech Easier. Over the years, he has grown a reputation for publishing quality guides, reviews, tips, and explainer articles. His work is featured on top websites, including Technical Ustad, Windows Report, and Next of Windows. He has training as a Microsoft Certified Professional and has covered more Microsoft-related guides on these platforms.

The context menu has a series of shortcuts for performing actions. You may use it to open the Edit Hyperlink Dialog and extract your hyperlinks. Here’s how:

Step 1:Launch Excel on your computer and open the document with hyperlinks.

Step 2:Click on theSheettab with the hyperlinks and select the cell with the hyperlinks.

Step 3:Right-click the cell with the hyperlink to launch the context menu.

Step 4:SelectEdit Hyperlinkto launch the Edit Hyperlink dialog box.

Step 5:Place your mouse cursor in theAddressfield of the Edit Hyperlink dialog box to highlight the URL.

Step 6:Right-click the highlighted URL and selectCopy. Alternatively, you can use the shortcutCtrl+Cto copy the URL.

Step 7:ClickOKto close the Edit Hyperlink dialog box.

Step 8:Finally, right-click the Excel document or the document where you would like to place the extracted links and selectPaste. Alternatively, you can paste the URL using theCtrl+Vshortcut.

If thehyperlinks in your Excelworkbook do not work, try checking the link path, repairing the workbook, or running the Office repair tool to fix it.

Method 2: Using Word Processors

You can use Word and an HTML reader like Notepad to extract hyperlinks from a moderately sized data set. Copy the hyperlinks from your Excel to a Word document, then save the Word document as HTML. Here’s how:

Step 1:Launch Excel on your computer and open the document with hyperlinks.

Step 2:Click on theSheettab with the hyperlinks and copy all cells with the hyperlinks.

Step 3:Open a new Word document and paste the copied hyperlinks into the document.

Step 4:PressCtrl+Sto launch the Save window in Microsoft Word. Alternatively, click theFiletab on the Ribbon and selectSave Asto launch the Save As window.

Step 5:Enter a name for your file in theFile namefield.

Step 6:Click theSave astype drop-down andselect .html.

Step 7:ClickSaveto create the .html file.

Step 8:Open your Windows File Library and navigate to the location with your saved .html file.

Step 9:Right-click on the file, clickOpen with, then selectNotepad.

Step 10:Copy the content of the HTML file and paste it into a Word document.

Step 11:Click theCtrl+Hkeys on your keyboard to launch the Find and Replace dialog box. Alternatively, click theReplacebutton on theHometab.

Step 12:In theFind whatfield, enter the unwanted code surrounding the hyperlink.

Step 13:In theReplace withfield, leave a blank space and clickReplace All. This ensures all unwanted code are replaced with a blank space.

Step 14:Repeat steps 12 and 13 to remove all unwanted code until only the hyperlinks are left.

Step 15:Lastly, copy the hyperlinks and transfer them to a blank column in Excel.

Method 3: Using VBA Code

With VBA, you can create a code to help you extract the hyperlinks within a short amount of time. This is particularly useful when working with a large data set. Here’s how to do so:

Step 1:Launch Excel on your computer and open the document with hyperlinks.

Step 2:Click theAlt+F11keys on your keyboard to open the VBA window.

Step 3:On the VBA window, click theInserttab.

Step 4:SelectModulefrom the options to launch the Module window.

Step 5:Copy and paste the following code into the Module window.

Step 6:Click theRuntab and selectRun Sub/UserForm.

Step 7:Lastly, close the VBA window by clicking theAlt+Qkeys. Your extracted hyperlinks should show up in a new column.

Was this helpful?

Last updated on 20 July, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

How to Change or Remove Your Last Name on Facebook

How to Use WhatsApp on Two Phones With the Same Number

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.