How to extract the url in a hyperlink using a formula
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
"pako_1972" wrote:
I am trying to figure out how to extract the actual url from a field that
shows the friendly name as the link.
|