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 *