Parse hyperlink from visible text

[Duane]

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

 

[Gary''s Student]

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

 

[Duane]

Thanks. I will give it a try.

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