How to Extract URL From Hyperlink in Excel | How to Extract EMAIL-ID from Hyperlink in Excel
How to Extract URL From Hyperlink in Excel | How to Extract EMAIL-ID from Hyperlink in Excel
#excel
#msexcel
#microsoftexcel
#msexceltutorial
Let's say you have a hyperlink in a cell in Excel. The hyperlink may have friendly text, such as Click Here, but when you click the link it takes you toa specific
URL. Now, let's say you want to extract that URL from the hyperlink using an Excel formula.
Well .. to my knowledge, there isn't a built-in function to accomplish that. But, we can actually create our own custom function, and even name it URL if we'd
like, using a few lines of code. I'l walk you through each step so it will be easy to implement. And thanks to my friend Cary who asked how to extract a url from a hyperlink which led to this video!
Code to create the custom URL function (paste into
VB Editor):
Function URL(Hyperlink As Range)
URL Hyperlink.Hyperlinks(1).Address
End Function