Data validation in excel data>form

[William]

I have several columns in a spreadsheet that need to be
entered in a certain form.
dat and time is easy but i need 1 column to be able to
accept EITHER
AANNNN (2 ALPHAS 4 NUMERICS)
OR
NOOP (NO OPERATION)
SO
DAY 1 XX1234
DAY 2 XX2213
DAY 3 NOOP

I believe I can create a "pre-ordained" list but the
problem is I am not always sure of the numerics following
the 2 alphas

Any suggestions would be appreciated

 

[Dave Peterson]

Maybe you could try John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

If you like it and want to customize it, it's pretty reasonable price to get to
the source code ($20 USA).