How to extract the url in a hyperlink using a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how to extract the actual url from a field that
shows the friendly name as the link.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Extract Hyperlink URL as String - Access 2010 0
Multiple Logic in One Formula 0
Extract the 2 Lowest % 3
Extract Supplier Name 2
Hyperlink to the meat of a cell 4
Calculate Revenue based on dates within a month 4
Can UDF return a customized hyperlink? 3
How can I display the text of a hyperlink? 4

Back
Top