Hyperlinks

1

1 of 1

I've copy/pasted information from a web page into an Excel worksheet. The
information in my new worksheet is in the form of hyperlinks which I don't
want.
Is there anyway of deleting hyperlinks (all in the same column) in bulk?
 
D

Dave Peterson

Select the range to clean up (ctrl-a a few times will select all the cells)
hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:

selection.hyperlinks.delete
 
Top