Thanks for the response!
I think this is 'backwards'of what I want. That data that I am copying is
in table form. Some of the 'cells' in the copy are hyperlinks. When I paste
it I want to disable the hyperlink.Thanks
Jan

"JE McGimpsey" wrote:

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