EXCEL 提取单元格值中特殊符号的前后值?答:回答:如图: B1公式: =--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,")",""),"(",REPT(" ",10)),"/",REPT(" ",10)),(COLUMN(A1)-1)*10+1,10) 右拉到C1,再下拉。
Excel中截取指定特殊符号之前,之中、之后的数据答:B1公式:=MID(A1,FIND("×",A1,1)+1,FIND("×",MID(A1,FIND("×",A1,1)+1,LEN(A1)-FIND("×",A1,1)+1),1)-1)C1公式:=MID(MID(A1,FIND("×",A1,1)+1,LEN(A1)-FIND("×",A1,1)+1),FIND("×",MID(A1,FIND("×",A1,1)+1,LEN(A1)-FIND("×",A1,1)+1),...
怎么用EXCEL函数提取由字母符号数字组合成的句子里面“特定字母”旁边的...答:出现位置在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))),"/*",""))-1)即可提取出想要的数字。