Welcome to ozgrid.com
Here is the best way I know of.
Select any cell that has the character you want removed.
Form the Formula Bar highlight the character only then copy (Ctrl+C).
Now go to Edit>Replace.
In the Find what: box paste (Ctrl+V) the clipboad content.
Leave the Replace with: box empty and click Replace All.
To find out the character code you can paste it into an empty cell then reference it with the CODE function. For example