E2{=MID($D2,SMALL(IF(1-ISERR(-MID(SUBSTITUTE($D2," ","@")&"@",ROW($1:$99),16)),ROW($1:$99),99),COLUMN(A1)),16)
另解{=MID(D$2,SMALL(IF(MMULT(N(LENB(MID(D$2,ROW($1:$99)+{0,1,2},1))={2,1,1}),{1;1;1})=3,ROW($2:$100),99),ROW(A1)),16)
另解{=MID(D$2,SMALL(IF(MMULT(1-ISERR(-MID(D$2,ROW($1:$99)+COLUMN(A:P)-1,1)),ROW(1:16)^0)=16,ROW($1:$99),99),ROW(A1)),16)
留言
張貼留言