拆分自動換列表格 (11229)

I3K10=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM($B$2),":"," "),CHAR(10)," ")," ",REPT(" ",99)),(ROW(A1)*3-3+COLUMN(A1))*99-98,99))

另解=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM($B$2),":"," "),CHAR(10)," ")," ",REPT(" ",99)),(ROW(A1)-1)*297+COLUMN(A1)*99-98,99))