How to split English and Chinese characters to different cells

Question

I encounter the data including Chinese and English names in one column, which I want to split to different column, but the length in each line for the Chinese and English is not the same.

Sample.xlsx

zhanghongtao · Answer

Thank you so much for your help!

Yoshiro_Fujimori · Answer

You can use RegEx Tool with the configuration below;

Regular Expression: ([a-zA-Z0-9_\s,]+)\s([^a-zA-Z0-9_\s,].*)

Output Method: Parse

Then you will get the output as below:

NameName1Name2Wei, Quan Quan 韦, 泉全Wei, Quan Quan韦, 泉全Wei, Ting 韦, 婷Wei, Ting韦, 婷Xue, Hui Jing 薛, 惠菁Xue, Hui Jing薛, 惠菁Zhang, An Qi 张, 安芪Zhang, An Qi张, 安芪Zhang, Min 张, 敏Zhang, Min张, 敏...

RegEx.yxmd