Changing a symbol every time

R

Rich

In my spreadsheet every ' (an apostrophe) has been replaced with Õ (an O with an accent). This has happened in hundreds occasions in the (very large) spreadsheet. Is there a quick way I can search for every Õ and replace it with an ' ?
 
A

Alan

That character is ASCII 213, or in Excel CHR(213)
Go Edit > Replace, In 'Find What' hold down the Alt key and type 0213, in
Replace With enter '
Replace All > OK
Personally I would make a copy of the sheet first!
Regards,
Rich said:
In my spreadsheet every ' (an apostrophe) has been replaced with Õ (an O
Click to expand...
with an accent). This has happened in hundreds occasions in the (very large)
spreadsheet. Is there a quick way I can search for every Õ and replace it
with an ' ?
 
Top