I read a previous article and non of the formulas worked for my worksheet.
I need to validate a cell for the following custom format, but cant get it to work:
1. XX00000
2. 00000000XX
3. 000000X
Where XX is any combination of letters (upper or lowercase) and
00000 is a combination of any 5 numbers.
All of these formaulas can not allow special characters.
It must always be in this format, with this number of digits in total on each
I need to validate a cell for the following custom format, but cant get it to work:
1. XX00000
2. 00000000XX
3. 000000X
Where XX is any combination of letters (upper or lowercase) and
00000 is a combination of any 5 numbers.
All of these formaulas can not allow special characters.
It must always be in this format, with this number of digits in total on each