Hello,

I have an intake of name data in three columns: First Name, Middle Name and Last Name.

I have then got a formula to join them up in a fourth columns:

E.g., Selma Anna Żakowicz will become: Żakowicz/Selma Anna

Joined Up Formula:

=[Last Name]@row + "/" + [First Name]@row + " " + [Middle Name]@row

This joined up column will then be copied into another system. However, this system removes any characters that have an accent. So in the example of above it will delete the 'Ż' .

Is there any way to ask Smartsheet to replace accented characters with their non-accented counterparts in the joined up formula

There are obviously lots of accents to cover but these are the top five to get started if possible:

1. á replaced by a
2. é replaced by e
3. í replaced by i
4. ó replaced by o
5. ú replaced by u

Thanks for your help.