Forum Discussion
Excel Data Validation of a Specif Format - Alpha Numeric
I wish to setup an Input Validation where-in My the input has to be XXXX9999X format where X is a character and 9 is digit. How can I Set this Validation for Data Entry, and the length has to be exact 10 characters. I am only able to fix the length not the required input format of XXXX9999X.
Try this
=AND(LEN(A1)=10,SUMPRODUCT(--(--(ISNUMBER(MID(A1,{1,2,3,4,5,6,7,8,9,10},1)+0))={0,0,0,0,0,1,1,1,1,0}))+SUMPRODUCT(--(CODE(MID(UPPER(A1),{1,2,3,4,5,10},1))>64))=16)
