Hi,

Make an upper case list of all possible state abbreviations. Select the
cell(s) where you want the data validation and choose Data, Validation, and
pick Custom from the Allow list. Enter the formula
=OR(EXACT(F1,$G$1:$G$50))

If you don't want to enter the list in uppercase you can use

=OR(EXACT(E1,UPPER($G$1:$G$50)))

instead

Here the first cell to in column F that I want to validate is F1 and I have
put a list of Upper case codes in the range G1:G50.

If this helps, please click the Yes button

Cheers,
Shane DEvenshire


"Wanna Learn" wrote:

Hello column "F" is for states and I only want the abbriviation of each
state as follows 2 alpha charatects in upper case letters e.g. NY I
formatted the column as text but how do I do the data validation for two 2
characters and upper case letters or is there and easier way? VBA? thanks in
advance