EXCEL 里提取多组数字,如：A1: 01 02 03 04 05 我要A2:01 A3:02 A4:03

假设你每组数是用空格隔开的.在A2输入下面公式,然后以CTLR+SHIFT+ENTER确认.然后向下填充就可以了.你可以填充的多点,如填充到1000行.这样你只要在A1中不断添加新的数组,A2:A1000也会不断地随更新而增加

=IF(ROW(A1)>LEN($A$1)-LEN(SUBSTITUTE($A$1," ",""))+1,"",MID(SUBSTITUTE(" "&$A$1&" "," ","@",ROW(A1)),FIND("@",SUBSTITUTE(" "&$A$1&" "," ","@",ROW(A1)))+1,SMALL(IF(MID(" "&$A$1&" ",ROW(INDIRECT("1:"&LEN(" "&$A$1&" "))),1)=" ",ROW(INDIRECT("1:"&LEN(" "&$A$1&" "))),""),ROW(A2))-SMALL(IF(MID(" "&$A$1&" ",ROW(INDIRECT("1:"&LEN(" "&$A$1&" "))),1)=" ",ROW(INDIRECT("1:"&LEN(" "&$A$1&" "))),""),ROW(A1))-1))

如果你的每个数据的长度均为两位,且有一空隔分开:
A2=MID(A1,3*(ROW(1:1)-1)+1,2)
将公式向下复制.

A2=left(A1,2)
A3=mid(A1,3,2)
A4=mid(A1,5,2)