Extracting hyperlink from a cell
 

Okay.. so I have a list of hyperlinks in my spreadsheet. I need a way
to split the hyperlink column into two columns, one with the
http://website.com part and one with the text of the hyperlink, any
ideas on how to do this?

Thanks for your help.


--
giraph
------------------------------------------------------------------------
giraph's Profile: http://www.excelforum.com/member.php...o&userid=31447
View this thread: http://www.excelforum.com/showthread...hreadid=511351

Extracting hyperlink from a cell
 

This tiny UDF will return the URL:

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

So if A1 has a hyperlink, then =hyp2(A1) will give the address.


=A1 will give the description
--
Gary's Student


"giraph" wrote:


Okay.. so I have a list of hyperlinks in my spreadsheet. I need a way
to split the hyperlink column into two columns, one with the
http://website.com part and one with the text of the hyperlink, any
ideas on how to do this?

Thanks for your help.


--
giraph
------------------------------------------------------------------------
giraph's Profile: http://www.excelforum.com/member.php...o&userid=31447
View this thread: http://www.excelforum.com/showthread...hreadid=511351