C2单元格输入公式=MID(PHONETIC(B$2:B$100),FIND("@",SUBSTITUTE(PHONETIC(B$2:B$100),"B","@...
C2单元格输入公式=MID(PHONETIC(B$2:B$100),FIND("@",SUBSTITUTE(PHONETIC(B$2:B$100),"B","@",ROW(A1))),12)下拉到错误符号出现为止。 如图：（提取出来后筛选一下将C列的重复数据删除即可）示例