(2007版)F2{=IFERROR(TRIM(MID(SUBSTITUTE(INDEX(B:B,SMALL(IF(LEN(B$2:B$5)-LEN(SUBSTITUTE(B$2:B$5," ",))+1>=COLUMN(A:I),ROW($2:$5)),ROW(A1)))," ",REPT(" ",99)),RIGHT(SMALL(IF(LEN(B$2:B$5)-LEN(SUBSTITUTE(B$2:B$5," ",))+1>=COLUMN(A:I),ROW($2:$5)/1%+COLUMN(A:I)),ROW(A1)),2)*99-98,99)),"")
H2:L5=TRIM(MID(SUBSTITUTE($B2," ",REPT(" ",99)),COLUMN(A1)*99-98,99))
N2{=IFERROR(INDIRECT(TEXT(SMALL(IF(H$2:L$5<>"",ROW($2:$5)/1%+COLUMN(H:L)),ROW(A1)),"!R0C00"),),"")
留言
張貼留言