使用Excel函数拆分单元格数据分开中文与英文

1、理论分析：Assume a string s contains x+y characters;x is the number of C茑霁酌绡hinese characters;y is the number of English characters;LEN(s)=x+y;LENB(s)=2*x+yx=LENB(s)-LEN(s)y=2*LEN(s)-LENB(s)if there is a special character in the string;can devide the string into two substring;usethis special character.function:FIND()

2、使用Excel函数演示

3、也可以用于检测单元格中是否含有中文