急~求助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里如何取一个单元格里的数字答:假设数据在A列 使用通用公式 B1=LOOKUP(9E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&5^19)),ROW($1:$99)))