Value Left - Working with single and double digits


Hello, For the below formula I am attempting to grab the leading numbers from an alphanumeric field. the numbers will always be leading but will range between 1-and 10.

I am using the following with no success

=VALUE(LEFT([Probability Score]@row, 2))

If the cell contains 10 then it works. But if it contains a single-digit number it fails. If I use:

=VALUE(LEFT([Probability Score]@row))

Then I only get a single-digit return.

I have attempted to use helper columns but to no avail yet.

The intent is to multiple two fields together using the formula above. See screenshot for reference.

Best Answer