提取数值求和

qtzjy126 · 发表于 2024-7-10 16:05

提取数值求和

求提取 B2 单元格中的规格的和的函数公式

袁勇 · 发表于 2024-7-10 16:25

用EVALUATE自定义名称。

qwer401245 · 发表于 2024-7-10 16:28

hxj119 · 发表于 2024-7-10 16:30

=EVALUATE(REGEXP(B2,"[\d\*\+]+"))

niko88819 · 发表于 2024-7-10 16:32

=niko(B2)

Function niko(ByVal inputString As String) As Double
Dim cleanString As String
Dim i As Integer
Dim ch As String
For i = 1 To Len(inputString)
ch = Mid(inputString, i, 1)
If IsNumeric(ch) Or ch = "+" Or ch = "-" Or ch = "*" Or ch = "/" Or ch = "^" Or ch = "." Then
cleanString = cleanString & ch
End If
Next i
On Error Resume Next
niko = Evaluate(cleanString)
On Error GoTo 0
End Function

复制代码

leepoison · 发表于 2024-7-10 16:42

=MAX(IFERROR(EVALUATE(MID(B2,SEQUENCE(LEN(B2)),SEQUENCE(,LEN(B2)))),0))

我的城市你来过 · 发表于 2024-7-14 16:20

=EVALUATE(REGEXP(B2,"[0-9*+]+"))

		自动登录	找回密码
密码			免费注册

[求助] 提取数值求和