MRT replied to Anthony
21-Nov-09 12:10 AM
=IF(
(LEN(SUBSTITUTE(A2," ",""))=7)
*(SUMPRODUCT(--(CHAR(ROW(INDIRECT("a65:a90")))=MID(A2,{1,2,3},1)))=3)
*(SUMPRODUCT(--(CHAR(ROW(INDIRECT("a48:a57")))=MID(A2,{4,5,6,7},1)))=4),
but only according to my interpretation, 3 [A to Z] + 4 [0-9].
HTH
--
MRT