How to quickly and easily extract hyperlinks in Excel

Excel is undoubtedly a familiar spreadsheet software to all of us. Sometimes, you may need to extract a link from an Excel spreadsheet but unsure of how to do it. Follow the article below to learn how to extract a link in Excel!

0
180

1. How to extract links from an Excel file

Use the Edit Hyperlink tool to extract hyperlink in Excel

You can only extract one link by using Edit Hyperlink. If you have multiple hyperlinks, you need to repeat the steps for each extraction.

Step 1: Right-click on the cell with the Hyperlink > Select Edit Hyperlink.

Guide on how to quickly and easily extract links in Excel

Step 2:  Right-click on the cell with the Hyperlink > Select Edit Hyperlink.

Guide on how to quickly and easily extract links in Excel

Step 3: Close the dialog box and paste the link wherever you want.

Guide on how to quickly and easily extract links in Excel

2. How to extract links from an Excel file using VBA code

When you have too many hyperlinks, the manual method mentioned above can be time-consuming, so the following VBA code will help you extract multiple links from an Excel file at once in a faster way.

Step 1: In Excel, press ALT+F11 to open the Microsoft Visual Basic for Applications dialog box.

Step 2: Select Insert => Module, and paste the code:

Sub Extract Hyperlinks()  ‘Updateby20140318  Dim Rng As Range  Dim WorkRng As Range  On Error Resume Next  xTitleId = “Hoc Excel Online”  Set WorkRng = Application.Selection  Set WorkRng = Application.InputBox(“Range”, xTitleId, WorkRng.Address, Type:=8)  For Each Rng In WorkRng      If Rng.Hyperlinks.Count > 0 Then          Rng.Value = Rng.Hyperlinks.Item(1).Address      End If  Next  End Sub

Step 3: Press F5 to run the code, then a dialog box will appear asking you to select the hyperlinks you want to extract, as shown in the following image:

Guide on how to quickly and easily extract links in Excel

Step 4: Select OK, and the links will be converted into actual addresses.

Guide on how to quickly and easily extract links in Excel

3. How to extract links from an Excel file using a custom-made function

In addition to the above two methods, you can also extract links from an Excel file using a custom-made function. The steps are as follows:

Step 1: Press and hold ALT+F11 to open the Microsoft Visual Basic for Applications dialog box.

Step 2: Select Insert => Module, then paste the following code:

Function GetURL(pWorkRng As Range) As String  ‘Updateby20140520      GetURL = pWorkRng.Hyperlinks(1).Address  End Function

Step 3: Save the code and close the window, select an empty cell and enter the formula: =GetURL(A2) (A2 is the cell containing the hyperlink), then press Enter. You will immediately see the extracted link.

Guide on how to quickly and easily extract links in Excel

4. How to extract links from an Excel file using the Find and Replace tool

Using the Find and Replace tool to extract links from an Excel file will help you find the locations of cells containing links. Then, you can directly click on the cell address and open the hyperlink.

Step 1: Press the combination of Ctrl + F to open the Find and Replace dialog box > Select the Options item.

Press the combination of Ctrl + F to open the Find and Replace dialog box > Select the Options item.

Step 2: Select Format > Select Choose Format from Cell…

Select Format > Select Choose Format from Cell…

Step 3: Click on the cell that contains the link > In the Format section, the Preview will appear.

Click on the cell that contains the link > In the Format section, the Preview will appear.

Step 4: Click Find All > To display the cells that contain links.

Click Find All > To display the cells that contain links.

Conclusion

These are 4 extremely detailed and simple steps to extract links from an Excel file. If you have any questions related to the article, please leave a comment below for the fastest response.

You may also like

5 Essential Excel Functions for Beginners

Master the fundamentals of Excel with these 5 basic functions! Learn how to use SUM, AVERAGE, COUNT, MIN, and MAX in order to make calculating and analyzing data easier and more efficient.

A Simple Method for Adding Watermark to Excel for All Spreadsheets in No Time

Watermarking in Excel is a great way to mark your ownership and protect the content on your Excel spreadsheets. If you’re unsure how to do it, you can follow the steps outlined in this article.

How to recover unsaved or overwritten Excel files effectively: a sure-fire method

Knowing how to recover unsaved Excel files can be extremely helpful in cases when your computer unexpectedly shuts down or you accidentally click on “Don’t save” when Excel asks if you want to save your changes before closing. Follow this article to learn the step-by-step process of how to accomplish it.

5+ Effective Ways to Convert PDF to Excel Quickly, Useful Office Tricks

Knowing the ways to convert PDF files to Excel below will enable you to easily edit and add content inside. Office workers and students definitely must know this trick if they want to simplify their tasks.