在E2单元格输入公式=IFERROR(INDEX(IFERROR(MID($C2,FIND("@",SUBSTITUTE(" "&$C2&" "," ","@",COLUMN($A:$Z))),5),""),SMALL(IF(MATCH(IFERROR(MID($C2,FIND("@",SUBSTITUTE(" "&$C2&" "," ","@",COLUMN($A:$Z))),5),""),IFERROR(MID($C2,FIND("@",SUBSTITUTE(" "&$C2&" "," ","@",COLUMN($A:$Z))),5),""),)=COLUMN($A:$Z),COLUMN($A:$Z),4^8),COLUMN(A1)))&" ","")
数组公式,按Ctrl+Shift+Enter三键结束公式,使公式前后产生大括号{}后,下拉再右拉公式到空白单元格出现止。
在D2单元格输入公式=E2&F2&G2&H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2&W2&X2&Y2&Z2
下拉公式即可。 如图: