E2{=IFERROR(MID(A$1,SMALL(IF(MID(A$1,ROW($2:$199),1)=".",ROW($1:$198)),ROW(A1)),SUM(SMALL(IF(MID(A$1&" .",ROW($2:$199),1)=".",ROW($1:$198)),ROW(A1)+{0,1})*{-1,1})),"")
另解=IFERROR(MID(A$1,FIND("@",SUBSTITUTE(A$1,".","@",ROW(A1)))-1,IFERROR(FIND("@",SUBSTITUTE(A$1,".","@",ROW(A2))),LEN(A$1)+2)-FIND("@",SUBSTITUTE(A$1,".","@",ROW(A1)))),"")
留言
張貼留言