Excel提取任意位置数字的万能公式答:公式大揭秘:</ =TEXTSPLIT(TRIM(TEXTJOIN("",FALSE,IFERROR(IF(MID(A2,OFFSET({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},0,0),1)=".", ".", MID(A2,OFFSET({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},0,0),1)/1)," ")))," ...
excel公式嵌套,如何根据关键字符提取所需数据?答:用excel公式提取单元格中关键数据,可以用下面的方法完成。下面是实际操作。供参考。需要用到高版本OFFICE365中的TEXTSPLIT函数。公式如下:=MID(SORT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(A21,";",,1),"一","1"),"二","2"),"三","3"),,1,1),5,FIND(",",SORT(SUBSTITUTE(SUBSTITUTE...