Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse hyperlink from visible text
I was given a large Excel file which contains a column with visible text
("Map") in it, which contains an underlying hyperlink to a URL. Can I parse the hyperlink into another column? I can't find a way to do it, but it seems this should be a fairly simple function. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse hyperlink from visible text
If your hyperlinks are in column A, then first enter this UDF:
Function hyp(r As Range) As String hyp = r.Hyperlinks(1).Address End Function then in B1: =hyp(A1) and copy down -- Gary''s Student - gsnu200772 "Duane" wrote: I was given a large Excel file which contains a column with visible text ("Map") in it, which contains an underlying hyperlink to a URL. Can I parse the hyperlink into another column? I can't find a way to do it, but it seems this should be a fairly simple function. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse hyperlink from visible text
Thanks. I will give it a try.
"Gary''s Student" wrote: If your hyperlinks are in column A, then first enter this UDF: Function hyp(r As Range) As String hyp = r.Hyperlinks(1).Address End Function then in B1: =hyp(A1) and copy down -- Gary''s Student - gsnu200772 "Duane" wrote: I was given a large Excel file which contains a column with visible text ("Map") in it, which contains an underlying hyperlink to a URL. Can I parse the hyperlink into another column? I can't find a way to do it, but it seems this should be a fairly simple function. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
parse text string | Excel Worksheet Functions | |||
Some tabs not visible in Hyperlink list | Excel Worksheet Functions | |||
Parse text & numbers & format | Excel Worksheet Functions | |||
Parse text & numbers & format | Excel Worksheet Functions | |||
Parse text & Numbers | Excel Worksheet Functions |