One way:

=AND(LEN(A1)=1,OR(CODE(A1)=MEDIAN(CODE(A1),97,122) ,CODE(A1)=MEDIAN(CODE(A1),65,90)))


--
Biff
Microsoft Excel MVP


"Barb W" <Barb wrote in message
...
I am importing data into a spreadsheet. I want to check whether certain
columns contain valid data. So if columns A and D, for instance, need to
be
"character", I would want to check that the value in any given field is
A-Z
or a-z. Is there a quicker way than using "OR" and typing out the 52
possibilities?