Remove ÿ

O

Otto Moehrbach

Excel XP, Win XP
A friend has a file that has a number of the subject "ÿ" (without the
quotes) in many cells and wants to remove them. I tried Edit - Replace and
tried to paste the "ÿ" into the Replace box but that didn't work. How can
he remove these "ÿ"s? Thanks for your time. Otto
 
B

Biff

Get the ascii code number of the offending character:

=CODE(A1)

In my test sheet using the Arial font that code number is 255.

Edit>Replace
Find what: hold down the ALT key and using the *numeric keypad* type 0255
Replace with: nothing, leave this empty
Replace All

Biff
 
Top