I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank.

I have already found the formula for the desired format.

=IF(AND(LEN([APC Standard])=7,LEFT([APC Standard],3)="APC",ISNUMBER(0+RIGHT([APC Standard],4))),TRUE,FALSE)

However, I cannot find a way to leave the column blank.

Can someone please help me?

1 Answer 1


If you have already found the formula for your desired format, you can use below to check if the column is blank or not:

=IF(ISBLANK([APC Standard]), TRUE, IF(AND(LEN([APC Standard]) = 7, LEFT([APC Standard], 3) = "APC", ISNUMBER(0 + RIGHT([APC Standard], 4))), TRUE, FALSE))


  1. Calculated Field Formulas
  2. IS functions - ISBLANK

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.