Converting written accents

[johnnykoung]

Hi,

The text I'm reading in has some accents above certain letters. Is there an easy way to remove the accents? For example: La Révolution should be converted to La Revolution, or NIÑO SANTO should be converted to NINO SANTO.

Thanks in advance!

Johnny

[BrandonB · Accepted solution]

Try this formula in a formula tool: DecomposeUnicodeForMatch([string])

[johnnykoung]

Exactly what I needed, thank you!