单元格内用公式提取相同的数字?请大师帮忙!答:B1公式下拉:=IF(LEN(A1)-LEN(SUBSTITUTE(A1,0,))>1,0,"")&SUBSTITUTE(SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,ROW($1:$9),))>1)*ROW($1:$9)*10^(9-ROW($1:$9))),0,)D1公式下拉:=IF(LEN(C1)-LEN(SUBSTITUTE(C1,0,))>1,0,"")&SUBSTITUTE(SUMPRODUCT((LEN(C1)-LEN(...
excel单元格提取数字答:50)," ",)="","/",SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($A1,"*",REPT(" ",50)),"\",REPT(" ",50)),COLUMN(A1)*50-49,50)," ",))向下向右复制也可以像qwe3212630 回答的那样分列,但是在分列前先把分列标志统一起来:用查找替换把星号或斜杠替换成斜杠或星号,再分列一次完成。