取固定位置數值 (11653)

B2:C4=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"-","."),".",REPT(" ",99)),COLUMN(C1)*99-98,99))

D2:E4=TRIM(LEFT(RIGHT(SUBSTITUTE($A2,".",REPT(" ",99)),(3-COLUMN(A1))*99),99))

一式公式 B2:E4=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"-","."),".",REPT(" ",99)),(COLUMN(C1)+(COLUMN(A1)>2)*2)*99-98,99))

一式公式 B2:E4=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"-","."),".",REPT(" ",50)),50*CHOOSE(COLUMN(A1),3,4,7,8)-49,50))