is it possible to replace ascii characters using find and replace?

[learning_grexcel]

I often come across situation when I copy and paste data from web pages, the data contains unknown characters usually ascii code 160 and few more.

I usually just insert additional column and use the formula text("values","0") to remove unknown characters.

Is there any possibility I can just simply replace using "ctrl + h" i.e. find and replace ?

 

[shg]

In the find box, press and hold the Alt key, amd on the NUMERIC keypad, enter 0160 (the code for a non-breaking space). Replace with a normal space.