Extracting hyperlink from a cell

[giraph]

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.

 

[Guest]

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