excel运算数字文字求和,例如A1单元格中室外13+室内25+走道2*5-池边8...答:给你个自定义函数吧 Function 计算(区域 As Range)Dim Rng As String, i As Integer, Str As String For i = 1 To Len(区域(1))If Val(Mid(区域(1), i, 1)) > 0 Or Mid(区域(1), i, 1) = "0" Or Mid(区域(1), i, 1) = "+" Or Mid(区域(1), i, 1) = "-" ...
excel表格中有文字和数字一起,怎样求和?答:楼上的答案很巧妙 =RIGHT(B1,LEN(B1)-SMALL(IF(ISNUMBER(MID(B1,ROW($1:$20),1)*1),ROW($1:$20)),1)+1)+RIGHT(C1,LEN(C1)-SMALL(IF(ISNUMBER(MID(C1,ROW($1:$20),1)*1),ROW($1:$20)),1)+1)+RIGHT(D1,LEN(D1)-SMALL(IF(ISNUMBER(MID(D1,ROW($1:$20),1)*1),...