如图,B2输入公式右拉,下拉。=MID(LEFT($A1,2*LEN($A1)-LENB($A1)),FIND("@",SUBSTITUTE("*"&LEFT($A1,2*LEN($A1)-LENB($A1))&"*","*","@",COLUMN(A1))),FIND("@",SUBSTITUTE("*"&LEFT($A1,2*LEN($A1)-LENB($A1))&"*","*","@",COLUMN(B1)))-1-FIND("@",SUBSTITUTE("*"&LEFT($A1,2*LEN($A1)-LENB($A1))&"*","*","@",COLUMN(A1))))