excel表格相加怎么忽略文本

1.excel如何忽略文字计算

用自定义函数吧

Function cal(rng As Range)

Dim reg As Object

Set reg = CreateObject("vbscript.regexp")

With reg

.Pattern = "[\((].+?[\))]"

.Global = True

cal = Application.Evaluate(reg.Replace(rng, ""))

End With

End FunctionAlt+F11》弹出窗口中，选插入》模块》粘贴以上代码，关闭窗口，excel中输入公式=cal(C112)