excel: extract url from hyperlink

excel does not have a native way to do this, buy you canĀ  create a function using a visual basing script/

 

Open VB ALT+F11

 

create the following script:

 

Function URL(Hyperlink As Range)

URL = Hyperlink.Hyperlinks(1).Address

End Function

 

Leave a Reply

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