Hyperlink text
 

I have a hyperlink, in a cell, say cell A1.

This text, for example it may say 'blah', is then hyperlinked to a webpage,
say www.hyperlink.com.....ie the text is not related to the name of the
hyperlink.

Is there a way i can then get the actual hyperlink, www.hyperlink.com, to
appear in the next column?

Hyperlink text
 

Yes:

enter this tiny UDF:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function

if A1 has a hyperlink in it then
=hyp2(A1) will display the URL (address part)
--
Gary's Student


"Frazer" wrote:

I have a hyperlink, in a cell, say cell A1.

This text, for example it may say 'blah', is then hyperlinked to a webpage,
say www.hyperlink.com.....ie the text is not related to the name of the
hyperlink.

Is there a way i can then get the actual hyperlink, www.hyperlink.com, to
appear in the next column?