How to extract the url in a hyperlink using a formula
 

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

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.