Remove ÿ
 

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

Remove ÿ
 

Get the ascii code number of the offending character:

=CODE(A1)

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

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

Biff

"Otto Moehrbach" wrote in message
...
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

Remove ÿ
 

That's a new one on me. I guess MS doesn't give us any damping.

"Biff" wrote:

Get the ascii code number of the offending character:

=CODE(A1)

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

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

Biff

"Otto Moehrbach" wrote in message
...
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