Avatar of gregholl
Flag for Ecuador

asked on 

how to use an excel formula to remove accent marks from characters, like ñ é ü í ó

I have a list of customers address. Some folks from Germany, Sweden, etc., have funny squiggles above or below many of the letters. I would like to make a simple formula to take the letter and then replace it with a regular ASCII letter that won't cause me any errors in my shipping application.

i.e. say column A has the original address with all the tildes, accents and squiggles. Column B will return the same complete address, but with the necessary letters replaced with the standard ASCII equivalent. Column B will be the "clean" list.

Can you please help?

Microsoft ExcelFonts Typography

Avatar of undefined
Last Comment

8/22/2022 - Mon