excel单元格中提取第N个指定字符前的字符。答:=LEFT(A2,FIND("@",SUBSTITUTE(A1,"-","@",2))-1)=LEFT(A2,FIND("@",SUBSTITUTE(A1,"/","@",3))-1)
在EXCEL的单元格A1中把第n个“,”和第n-1个“,”之间的字符串提取出来的...答:FIND(",",A1,n)的方法找是不行的,因为这里的n是指从第n个字符开始找,而不是从第n个逗号开始找,意思不一样,当然无法查找了。用下面公式可以实现 =MID(A1,FIND("@",SUBSTITUTE(A1,",","@",n))+1,FIND("@",SUBSTITUTE(A1,",","@",n))-FIND("@",SUBSTITUTE(A1,",","@",n-...