这个用公式比较复杂,B1中输入
=TRIM(TEXT(MID(SUM(SMALL(IF(ISERR(FIND(TEXT(ROW(INDIRECT(--LEFT(A1,2)&":"&--RIGHT(A1,2)))," 00 ")," "&A1&" ")),ROW(INDIRECT(--LEFT(A1,2)&":"&--RIGHT(A1,2)))),ROW(INDIRECT("1:"&RIGHT(A1,2)-LEFT(A1,2)-(LEN(A1)+1)/3+1)))/10^(ROW(INDIRECT("1:"&RIGHT(A1,2)-LEFT(A1,2)-(LEN(A1)+1)/3+1))*2)),3,(RIGHT(A1,2)-LEFT(A1,2)-(LEN(A1)+1)/3+1)*2),REPT("00 ",RIGHT(A1,2)-LEFT(A1,2)-(LEN(A1)+1)/3+1)))
同时按下CTRL+SHIFT+回车,输入数组公式,下拉.
返回结果中,数字个数受限制,你可以输入各种原始数据,试试.