拆分三段 空白格數不固定 (11696)

日期：

C2:E6=TRIM(MID(SUBSTITUTE(SUBSTITUTE(" "&$B2," ",REPT(" ",99),LEN($B2)-LEN(SUBSTITUTE($B2," ",))-1+COLUMN(A1))," ",REPT(" ",99),(LEN($B2)-LEN(SUBSTITUTE($B2," ",))-2+COLUMN(A1))^(COLUMN(A1)>1)),99,99))



留言

張貼留言