If the number is always at the start, tryI wants a formulla which can easillly seprate numeric+text to numeric
like 1234aritra to 1234
1aritra to 1
1a to 1
in a single formulla
Function GetNumber(r As String) As Double
GetNumber = Val(r)
End Function