Remove links

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I am copy and pasting data from webpages into Excel. When
I do the paste the links stay intact. Is there a way to
break or remove the links without having to highlight them
all?
TIA
George
 
Hit alt-f11 to get to the VBE (where macros live)
then hit ctrl-g to see the immediate window
then type this and hit enter
cells.hyperlinks.delete
 
You must log in or register to reply here.

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

How can I change text copied to excel from webite to not link bac. 1
Copying linked sheet 2
How to get rid of web page objects ? 9
Mirroring excel file content 2
Text not date 4
Activating hyperlinks 3
Invisible Link 4
Changing Cell Link on Spin Button Form Control 14

Back
Top