Need macro or code to replace Special ASCII characters with English alplabets

[Mayur_001]

Hi All,

Can you please provide me macro or code in Excel to replace Special ASCII Characters into Alphabet.

EG. For À, Á, Â.. i need Alphabet as A.. and for ß, Ɓ, Ƅ.. i need Alphabet as B.

Can i replace these special characters with correct English alphabets.

Let me know once you have any solution for this..

I have many of them to replace but wouldn't be able to do this as i am not expert in this please help.

regards,

Mayur

 

[RedBeard]

Have a look at this: performance - Replacing accented letters with regular letters in a spreadsheet - Code Review Stack Exchange