Replacing Special Char in a name

Hi @Saagar

This can be done with two tools:
Data Cleansing to remove symbols (©)
Formula to change accents back to their base letters (Ã)

Please find attached.

Cheers,
TheOC

Saagar.yxzp

Qiu

@Saagar
I would suggest to use a Find and Replace Tool.

And a manually maitenaned Dictionary for the replacement.

0228-Saagar.yxmd

atcodedog05

Hi @Saagar

You can use the formula tool replace function like below.

Hope this helps : )

replace char.yxmd

Saagar

I don't want to count names which are repeated

atcodedog05

Hi @Saagar

You are correct you would need to do like below

Hope this helps : )

replace char (1).yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703