Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
how do i remove hyphens from between numbers | Excel Worksheet Functions |