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

1、理论分析：

Assume a string s contains x+y characters;

x is the number of Chinese characters;

y is the number of English characters;

LEN(s)=x+y;LENB(s)=2*x+y

x=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;use

this special character.

function:FIND()

2、使用Excel函数演示

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