How to extract the url in a hyperlink using a formula

P

pako_1972

I am trying to figure out how to extract the actual url from a field that
shows the friendly name as the link.
 
B

Bill Pfister

Here is a solution if you don't mind using user-defined functions:


Public Function ShowHyperlink(rngHyperlink As Range) As String
If (rngHyperlink.Hyperlinks.Count > 0) Then
ShowHyperlink = rngHyperlink.Hyperlinks(1).Address
Else
ShowHyperlink = "no hyperlink"
End If
End Function

Regards,
Bill
 
Top