Hyperlinks

[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?

 

[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

 

[1 of 1]

Thanks heaps. You saved me about 3 hours of work.