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
|