EXCEL 提取单元格值中特殊符号的前后值?答:回答:如图: B1公式: =--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,")",""),"(",REPT(" ",10)),"/",REPT(" ",10)),(COLUMN(A1)-1)*10+1,10) 右拉到C1,再下拉。
怎么用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))),"/*",...