急~求助Excel中,如何在单元格内提取某个数值?答:假设你的单元格在A2开始的 第一对坐标,你自己搞定吧,不行你再发消息给我 最后一对坐标用如下公式:在B2中输入公式:=MID(TRIM(A2),FIND("a",SUBSTITUTE(TRIM(A2)," ","a",LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ",""))),1)+1,FIND("a",SUBSTITUTE(TRIM(A2),",","a",LEN(...
EXCEL 提取单元格值中特殊符号的前后值?答:回答:如图: B1公式: =--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,")",""),"(",REPT(" ",10)),"/",REPT(" ",10)),(COLUMN(A1)-1)*10+1,10) 右拉到C1,再下拉。