Extracting hyperlink from a cell

  • Thread starter Thread starter giraph
  • Start date Start date
G

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.
 
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
 
Back
Top