ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting text to the English alphabet in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/156910-converting-text-english-alphabet-excel.html)

Gra[_2_]

Converting text to the English alphabet in Excel?
 
I'm trying to reconcile two lists of names. My problem is that one list of
names contains true spellings, including characters from the Hungarian
alphabet (for example, accents, circumflexes, etc). The other list just uses
the English alphabet, and just drops all the special characters, replacing
them with the English alphabet equivalent. For example, an "a" with an
accent, just becomes an "a". "Gábor" becomes plain "Gabor".

Is there an easy way to convert the list using the Hungarian alphabet to the
English equivalent?


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com