Excel 2007 : Input Mask for Cell Data

Hi,

I'm trying to use some sort of input mask for cell data entry. The cell is for a car registration (new style) so it will be fixed at two letters followed by two numbers a space and then three letters... AA02 AAA. Im using excel 2007.

Can anyone help me with this? It seems so simple but yet so hard...

Cheers,
Adzi

Welcome to the forum.

This returns TRUE if for a valid string:

=AND(LEN(A1)=8, CODE(MID(A1, {1,2,3,4,5,6,7,8},1)) >= {65,65,48,48,32,65,65,65}, CODE(MID(A1, {1,2,3,4,5,6,7,8}, 1)) <= {90,90,57,57,32,90,90,90})