How To Extract URLs From Hyperlinks In Excel

Date:2021-4-28 Author:Sandra

If you need to save the URLs from hyperlinks. Will you click these hyperlinks one by one and save these URLs each time.

Today, Sandra will introduce a very easy and fast way to quickly make it, that’s VBA.

How To Extract URLs From Hyperlinks In Excel

As shown in the picture above, the data in the cells of column A have been inserted with hyperlinks, and now we need to extract the URLs of the hyperlink to the cells of column B. Go to the developer and click on Macros and create.

How To Extract URLs From Hyperlinks In Excel
How To Extract URLs From Hyperlinks In Excel

You can just copy and paste the code in following.

Function GetAdrs(Rng)

Application.Volatile True

WithRng.Hyperlinks(1)
        GetAdrs = IIf(.Address = “”, .SubAddress, .Address)
   End With

End Function

How To Extract URLs From Hyperlinks In Excel

Now, we back to the sheet and enter =getadrs(A1) in cell B1 and press enter key, then drop down to fill.

How To Extract URLs From Hyperlinks In Excel
How To Extract URLs From Hyperlinks In Excel

Ok, you have made it. Call it a day!

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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