excel单元格中不相邻的两个单元格中有文字和数字怎样提取数字相乘?_百度...答:=MID(B1,MATCH(0,0*MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1),),MATCH(0,0*MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1))-MATCH(0,0*MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1),)+1)*MID(D1,MATCH(0,0*MID(D1,ROW(INDIRECT("1:"&LEN(D1))),1),),MATCH(0,0*MID(D1...