Foreign letter replacement non-recognized characters

I need to replace the following list of characters with the english

e' ó ć č ū Š Á ý ģ ö ņ ž í ş š

there is code everywhere for how to do it but I am running into a simple issue

when I try replace several of the characters I get Cells.Replace What:="?", for example ū

guessing its simple just not finding the answer, thanks for any help

Perhaps
https://www.extendoffice.com/documen...haracters.html

but the characters if you were to use the code(function) display 63 in a lot of cases, and your first character e' is actually 2 characters!

These characters are all in names, will that matter? Thanks again

Thank you so much for the help!! the code works great

One issue that I am struggling with if I run the code with formulas set to manually calc excel crashes 60 to 70% of the time but given the sheet size if I run on automatic it takes 15 minutes to calculate all the altered formulas. Any additional help?