Handling of accented names use diacritical marks

Hi all,

It's my first time dealing with this kind of scenario in Excel where I have accented/diacritical characters in my text data. I'm trying to standardise them so that when I import to MySQL or Power BI it will at least be "readable" or understandable.

Here are some examples of text, I'm trying to clean up: Carmenè, Márga, Rosé, Gewürztraminer, etc.

How do you guys handle such in Excel? Do you change them to English alphabets or is there a way I can somewhat retain the accented/diacritical characters but, in manner that can be understood?

I greatly appreciate any advice or help from this community. Thank you :)

EDIT: There's a typo in the title, it's meant to read "Handling of accented names that\ use diacritical marks or characters"*.