How to remove Chinese language characters from the cell

[tushar_Kumar_bain]

Hi,

I just want to remove these Chinese language characters, what's the best way to go about it. Thanks!

[Qiu]

@tushar_Kumar_bain 
I think we can only keep the alphabets and some other characters you want by RegEx

[atcodedog05 · Accepted solution]

Hi @tushar_Kumar_bain 

Here is my take on this.

Workflow:

And interesting I didn't \u and \w capture Chinese characters too 🤔

Hope this helps : )

[binuacs]

@tushar_Kumar_bain Another RegEx option 

REGEX_Replace([姓名Name], '[^\x20-\x7e]+', "")

[binuacs]

@Qiu Thank you for providing some sample data 🙂

[Qiu]

@binuacs 
Welcome.
I happened to have OCR tool

[tushar_Kumar_bain]

Thanks a lot!

[atcodedog05]

Happy to help : ) @tushar_Kumar_bain 

If our response helps please don't forget to mark it as solution.

Cheers and have a nice day!