I have a requirement for a cell to contain "PO123456" where (123456 is >= 100000 and <= 999999) and to be rejected by data validation if:
thanks IA
- the first 2 characters are not 'PO'
- the remaining is not a 6-digit number within range
thanks IA