Changing a symbol every time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ' ?
 
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 ' ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you find and replace unwanted symbols in text cells? 2
Can I replace a ' at the beginning of a text cell using Replace 4
Can I assign keyboard shortcuts for special characters in Excel 20 1
Excel - fixing formatting 4
Find/Replace within links in cells 1
Excel changing Path of Formulas 5
Apostrophe's becoming upside down question marks on the web 3
keystroke to type the Ø symbol 4

Back
Top