View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP JP is offline
external usenet poster
 
Posts: 103
Default Extract text from hyperlink

I have an Excel sheet that contains a column of cells that are hyperlinks.
Is there a way to extract the text of the hyperlink? For example, the cell
contains a company, (Microsoft) that is hyperlinked to
http://www.microsoft.com. I would like to extract the
http://www.microsoft.com and put in a cell.

Thanks.