Formula to find special Foreign Language Letters with Accents (Diacritic marks)

[Melimob]

Hi there, hoping you could help. I've been given a spreadsheet containing names from European countries which use special accents/symbols over letters. I need to identify these for normalizing to English standard equivalent.

Please can you advise how I can filter or add a formula to find these? here's an example:

Cagáňová

Čampulková

Valkučáková

Bárta

Baláček

Zušťák

Bartoš

Bečvář

Zachariáš

Bártíková

Bajčík

<colgroup><col></colgroup><tbody>
</tbody>

Not contained in above but another example would be:

• ø, å.
• ä ö æ) ø å å, ä, ö.

many thanks in advance

 

[pgc01]

Hi

If what you want is to remove the diacritics, like replacing "á" with "a" or "ň" with "n", I posted code here (post #13), that identifies and replaces more than 500 characters:

http://www.mrexcel.com/forum/excel-questions/348352-convert-symbols-letters.html#13

the list with the symbols follows in post#14