D2{=LEFT(B2,MIN(FIND(ROW($1:$10)-1,B2&1/17))-1)
E2=-LOOKUP(1,-LEFT(SUBSTITUTE(B2,D2,),ROW($1:$9)))
F2=SUBSTITUTE(SUBSTITUTE(B2,D2&E2,),"x",)
一公式D2:F8{=TRIM(MID(SUBSTITUTE(REPLACE($B2,MIN(FIND(ROW($1:$10)-1,$B2&1/17)),,"x"),"x",REPT(" ",99)),COLUMN(A1)*99-98,99))
留言
張貼留言