How to split English and Chinese characters to different cells

[zhanghongtao]

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. 

[Yoshiro_Fujimori]

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:

Name	Name1	Name2
Wei, 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	张, 敏
...

[zhanghongtao]

Thank you so much for your help!