在excle表格中一个单元格内有3个信息分别用分隔符分开了想提取其中的一个，套用公式整列都能提取想要的信

推荐回答

是用哪个符号做分隔符？ 比如单元格是A2，用逗号分隔符。 =MID(A2,FIND(",",A2)+1,FIND(",",A2,FIND(",",A2)+1)-FIND(",",A2)-1) 也可 =MID(A2,FIND(",",A2)+1,FIND("@",SUBSTITUTE(A2,",","@",2))-FIND(",",A2)-1)