I need formulas for data validation to limit this information.
1. XX00000
2. 00000000X
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.
These can not be array formulas.
It must always be in this format, with this number of digits in total on each
By imputting a specific formula data validation this will only allow a user to type in this specific criteria.
Bookmarks