Value Left - Working with single and double digits

Josh ciaramitaro

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.

Paul H

This should remove the blank spaces on single digit values

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

Paul H

This should remove the blank spaces on single digit values

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

Kelly Moore

Hey @Josh ciaramitaro

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

Josh ciaramitaro

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