I am trying to find a good way to use Excel to determine whether a cell's first character is a number or a letter. I am using this to determine a flag that gets marked or not depending on the answer. Here is an example table:
**Status Code** Inactive 2AJ Active ALO Active PN9 Active Y2Y Inactive 1P9
Essentially, if the beginning character of the Code column is a numeric value, the Status column should show "Inactive". Currently I have this and it doesn't work:
=IF(ISNUMBER(LEFT(B1,1)),"Inactive","Active")
=IF(ISNUMBER(VALUE(LEFT(B2,1))),"Inactive","Active")
You were trying to see if a number stored as a string was a number. This fixes that issue.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With