View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
giraph
 
Posts: n/a
Default 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