Val Function

[Transformer]

This function returns the numbers found in a string which is passed as an argument.
It stops reading the string at the first character that it can't recognize as part of a number.
But it dont stop on spaces.

Syntax: Val(string)

Example:

Val("1234Excel")

would return 1234

Val("1234.5Excel")

would return 1234.5

Val("1234.5.56Excel")

would return 1234.5

Val("1234 23 34")

would return 12342334

Val("12323 .5  6")

would return 12323.56

Regards,
Transformer