How to remove Chinese language characters from the cell

Hi,

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

Datasets

Accepted answers

Here is my take on this.

Workflow:

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

Hope this helps : )

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

Here is my take on this.

Workflow:

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

Hope this helps : )

@tushar_Kumar_bain Another RegEx option

REGEX_Replace([&#22995;&#21517;Name], '[^\x20-\x7e]+', "")

@Qiu Thank you for providing some sample data 🙂

@binu_acs
Welcome.
I happened to have OCR tool