View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Take a look at:

http://www.mcgimpsey.com/excel/nohyperlinks.html


In article ,
Janice wrote:

Happy Holidays!

I am copying data from a webpage. Some of the cells are cmoing over as a
Hyperlink. Is there any way to strip the link and just leave the text that
is transferred from the webpage/
Thanks
Janice