Remove links

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
 
D

Dave Peterson

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
 
Top