怎么用EXCEL函数提取由字母符号数字组合成的句子里面“特定字母”旁边的...答:例如:字符串在A1单元格,特定字符在A3单元格,出现位置在B3单元格,在C3单元格输入=LEFT(SUBSTITUTE(RIGHT($A$1,LEN($A$1)-FIND(" ",SUBSTITUTE($A$1,A3," ",B3))),"/*",""),FIND("/",SUBSTITUTE(RIGHT($A$1,LEN($A$1)-FIND(" ",SUBSTITUTE($A$1,A3," ",B3))),"/*",...