拆分數據 (11818)

一公式B2:D8=INDEX(MID($A2,(FIND(0,$A2)-1)^{0,1,1}+{0,1,11},(FIND(0,$A2)-1)^{1,0,0}+{0,9,99}),COLUMN(A1))

B2=LEFT(A2,FIND(0,A2)-1)

C2=MID(A2,LEN(B2)+1,10)

D2=SUBSTITUTE(A2,B2&C2,)