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) = "-" ...