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 1and 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 singledigit number it fails. If I use:
=VALUE(LEFT([Probability Score]@row))
Then I only get a singledigit 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

This should remove the blank spaces on single digit values
=VALUE(SUBSTITUTE(LEFT([Probability Score]@row, 2), " ", ""))
Answers

This should remove the blank spaces on single digit values
=VALUE(SUBSTITUTE(LEFT([Probability Score]@row, 2), " ", ""))

Try this for your Column28. You should be able to use the same syntax for Column29
=VALUE(LEFT([Magnitude Score]@row, FIND("", [Magnitude Score]@row)  2))
Will this work for you?
Kelly

Many thanks for the quick assistance, but the options worked!