Is there a way to remove multiple hyperlinks at once?

[kufta4]

The format paint brush doesn't work. It looks like its gone but in reality its still there. Is there a way to do this? I'm copying and pasting many things into excel but don't want the hyperlink. Instead of removing each and every one, is there a way to do it at once? Thanks.

[Pete_UK]

If you have pasted into the sheet then leave those cells highlighted (or just select them again if you have clicked elsewhere). Then do Alt-F11 to bring up the VBE, then do CTRL-G to enter the immediate window, then type this:

selection.hyperlinks.delete

and press the <Enter> key.

That will remove all the hyperlinks in the selected cells.

Hope this helps.

Pete