Remove Hyperlink

J

Janice

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
 
J

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
 
J

Janice

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mass-remove hyperlinks from Publisher Document (VBA macro) 0
Can UDF return a customized hyperlink? 3
Copy hyperlinks 6
html hyperlinks using sub address 0
Hyperlinks with lookups 0
HyperLink to a folder on other drive on the same network (LAN) 6
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Combining three files when middle file has sections with endnotes 2

Top