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