Hi

P.e.
=AND(ISERROR(MID(A1,1,1)*1),ISERROR(MID(A1,2,1)*1) ,NOT(ISERROR(MID(A1,3,1)*1)),NOT(ISERROR(MID(A1,4, 1)*1)),LEN(A1)=4)
as validation rule


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"JohnUK" wrote in message
...
Hi,
I need a way to stop anything from being entered into a cell other than 2
letters and 2 numbers eg:
AA12 (Alpha Alpha Numeric Numeric)
Is there a way using validation to do this?
Many thanks
John