Hello guys,
I am thinking how to manage with several names in different languages.
I have got a column with names of people from different countries, now I have a several guys from Germany, some of them have umlauts in theirs names, then I create a next column with emails and I want to change umlauts to english description for example "ä → ae" .
But there was also some names with an apostrophe sign in and I think there also there will be added in future some other names with other diacritic signs. First think was to create an if statement with some array of key-values order and set up regex in formula to handled it.
So what do you think, how to manage this task?
Solved! Go to Solution.
Find Replace Tool?
Here's how I would do it:
Cheers,
Mark