software

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
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: www.excelforum.com/member.php...oamp;userid=31447
View this thread: www.excelforum.com/showthread...hreadid=511351This 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 Studentquot;giraphquot; wrote:

gt;
gt; Okay.. so I have a list of hyperlinks in my spreadsheet. I need a way
gt; to split the hyperlink column into two columns, one with the
gt; website.com part and one with the text of the hyperlink, any
gt; ideas on how to do this?
gt;
gt; Thanks for your help.
gt;
gt;
gt; --
gt; giraph
gt; ------------------------------------------------------------------------
gt; giraph's Profile: www.excelforum.com/member.php...oamp;userid=31447
gt; View this thread: www.excelforum.com/showthread...hreadid=511351
gt;
gt;