Create a list of the acceptable values. You can then use Data - Validation
- List to ensure that the input is valid. The only snag is that you can not
validate that the input was upper case that way. I personally would avoid
validating for upper case as the users will find it annoying. I personally
hate validation that says "I know exactly what you did wrong but instead of
handling the problem I am going to make you go back and fix it". You could
use custom validation if you really want, but I would be inclined to just use
the Upper function to convert the value to upper case in an adjacent cell.
--
HTH...

Jim Thomlinson


"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