exceltoxl.com

Hi there,

In this post, I will explain how to extract hyperlinks from Excel. 

MANUAL EXTRACTION:

We can extract hyperlinks by right clicking on the word/sentence which contains link and choose "edit hyperlink" and then copy the link in the "address" place as shown in the pic below.

...

AUTOMATE EXTRACTION:

We can automate this scenario using vba code as given below.

Sub ExtractHyper()
Dim Hyper As Hyperlink
For Each Hyper In ActiveSheet.Hyperlinks
Hyper.Range.Offset(0, 1).Value = Hyper.Address
Next
End Sub

This code will help you to extract the hyperlinks in excel.

If you are new or confused how to use this code in excel, then here you go:

1. Press ALT + F11 on the opened excel workbook which contains hyperlinks

2. Copy the code and paste it on a new module in Insert Option.

3. Finally, Press ALT + Q to exit from the vba window.

I have learnt this because I had a requirement today with my client. If you have the same requirement, use this technique and help your friends who might get needy using social networking sites placed around the blog.

DID YOU LIKE "ËXTRACT HYPERLINK IN EXCEL"?

Please share your thoughts or views about this post using below comments section. If you like this post, you can share it on your social networking sites by clicking on the icons placed around the blog.

To receive such updates, JOIN OUR FAMILY,.

SOME IMPORTANT LINKS:

Convert Number to Text

Count Colored Cells using Simple Function

List FileNames in a Folder

Count Worksheets in a Workbook

Thanks,