Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help extract numerous text files and how to use avg formula | Excel Worksheet Functions | |||
hyperlink to sheet in formula, can't save under new filename | Excel Worksheet Functions | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
jump to hyperlink, extract value at specific destination in file | Excel Worksheet Functions | |||
Can I extract text as a value from a formula? | Excel Worksheet Functions |