试试不用动态数组呢

=IF(ROW(A1)<=LEN(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1))-LEN(SUBSTITUTE(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1),".",""))+1,TRIM(MID(SUBSTITUTE(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1),".",REPT(" ",LEN(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1)))),(ROW(A1)-1)*LEN(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1))+1,LEN(LEFT($A$1,FIND(2,CONCAT(LENB(MID($A$1,ROW($1:$99),1))))-1)))),"")下拉