Val function in excel

[Leo_Polla_Psemata]

Hi,
in Access, we may have a text field like this Tare Weight 2100.000KG , and by using the Val function, we can make it like this Tare: Val([Tare Weight]) = 2100
Is there something similar and simple in excel?
To have a cell "10 t" and in function =sum, ignore text and use only digits ?

 

[Minty]

Amazingly the nearest thing is the Value() function.

VALUE function - Microsoft Support

Syntax: VALUE(text)

support.microsoft.com

 

[Leo_Polla_Psemata]

Amazingly the nearest thing is the Value() function.

VALUE function - Microsoft Support

Syntax: VALUE(text)

support.microsoft.com

Hi, not exactly, this convert a string that represent a number to a number
For example =VALUE("$1,000") converts to 1000

In my case, i have a cell 15 t (stands for 15 tones) , i cannot make calculation with only the number in it.

 

[Gasman]

I have google on my phone
https://www.ablebits.com/office-addins-blog/2017/11/22/excel-extract-number-from-string/

 

[arnelgp]

you can create a Function and call it:

Public Function mySum(r As Range)
Dim rng As Range, val As Double
Dim sUOM As String
    For Each rng In r
        If Len(sUOM) = 0 Then
            On Error Resume Next
            sUOM = Trim$(Split(rng, " ")(1))
            On Error GoTo 0
        End If
        val = val + CDbl(Split(rng, " ")(0))
    Next
    If Len(sUOM) Then
        mySum = val & " " & sUOM
    Else
        mySum = val
    End If
End Function

 

[Gasman]

Why not your own function with just

YourFunctionname = Val(WhateverYouPassToTheFunction)