yan:
EXCEL如何将字母+数字+汉字的组合拆分至单独的单元格如果中文全部在最后提取中文,=RIGHT(A1,LENB(A1)-LEN(A1))提取非中文=LEFT(A2,LEN(A2)*2-LENB(A2))1:LEFT(引用单元格,位数)即为从左取几位字符文本,LEN(A2)即为返回A2单元格的字符个数,LENB(A2)即为返回A2单元格的字符位数,与双字符集合用,LEN(A2)*2-LENB(A2)也就是A2单元格字符位数=LEFT(A2,LEN(A2)*2-LENB(A2))也就成了从左取A2....