Custom cell formatting question

[David Goodall]

Hi
I'm trying to format a cell so that only a certain format is accepted on
entry. I need the number/text inputed to be as follows: AA123456C where AA
and C can be any letters. I know you can choose particular letters by
enclosing the text in speech marks but the text must remain the same.

Any help greatly appreciated.

Thank you
David

 

[JE McGimpsey]

One way:

Data/Validation/Custom


=AND(CODE(LEFT(A1,1))>=65,CODE(LEFT(A1,1))<=90,CODE(MID(A1,2,2))>=65,CODE
(MID(A1,2,1))<=90,CODE(RIGHT(A1,1))>=65,CODE(RIGHT(A1,1)),ISNUMBER(MID(A1
,3,LEN(A1)-3)),LEN(A1)=9)