https://www.excelhome.net/lesson/animation/excel/1870.html
常用套路:
=INDEX(C:C,ROW(A1)*2)
=LEFT(C2,LENB(C2)-LEN(C2))
用LENB计算结果减去LEN计算结果,就是字符串中的双字节字符个数。
https://jingyan.baidu.com/article/fa4125ac23b23228ac70928e.html
https://www.excelhome.net/lesson/animation/excel/1945.html
EXCELhome各种教程