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

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

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