Replace/remove accented characters

Hi,
I have very large text data which contains accented characters (e.g., "ÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ?µ" etc.) within words. Since I have several data sheets, some of which having 500000+ rows, Find and Replace and similar options are not viable.


I wish to replace each of these characters with regular English characters in all sheets. If that is difficult, these must at least be removed from the whole text. Please note that I need to preserve regular characters that are commonly used, particularly the hyphen (-) and underscore (_).


I shall be very grateful for any help.


Best regards,
Guest2013

First you have to build an equivalence table

Basically, you would have 2 strings one containing the above mentioned characters and the other their replacements.

Once that is done you use the find() function in a loop (checking 1 character at a time) for every cell to be changed.

so if a match is found (find() will render the location within the string if any, delete the character and insert its replacement.

Hi @rcm and @popipipo,
Thanks for your response. I found a free-for-personal-use Add-in "ASAP Utilities" that has solved the problem.