You can use the Validation tool on the Data menu. Select the cell(s)
whose input you want to restrict, choose Validation from the Data
menu, change the "Allow" type to Custom and enter


=AND(ISNUMBER(LEFT(F1,1))=FALSE,ISNUMBER(RIGHT(F1, 1))=FALSE,LEN(F1)=2,EXACT(F1,UPPER(F1)))

Change F1 to the cell you are validating or the first cell if you are
validating multiple cells.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Tue, 2 Dec 2008 10:57:01 -0800, 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