How to get rid of symbols after deleting hyperlink

[Jella510]

Hi, can anyone help please?  How do I get rid of these symbols in bulk? I know I can go on individually right click and delete (and again).  TIA, Jella 

[#2]

@Jella510 

Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

Select Objects, then click OK.

Pressing Delete will now delete ALL objects on the sheet, so be careful!

[#3]

@hans_Vogelaar That's a bit scary as there is a lot of information already on the worksheet that I need to keep. Anyway around that?

[#4 · Accepted solution]

@Jella510

On the Home tab of the ribbon, in the Editing group, select Find & Select > Select Objects.

You can now use the mouse to drag a rectangle around all the items that you want to delete. Make sure not to include any other objects. If you do, you can Ctrl+click a selected item that you want to exclude.

Press Delete to remove the selected objects.

Finally, don't forget to turn off Select Objects!