Remove Hyperlink
 

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

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

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

Did you try it either of the macros in item 4?

In article ,
Janice wrote:

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

That got it I had some little error I deleted and renetered and it is working
now
Thanks so much for your help!
Janice

"JE McGimpsey" wrote:

Did you try it either of the macros in item 4?

In article ,
Janice wrote:

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