Data validation in excel data>form

  • Thread starter Thread starter William
  • Start date Start date
W

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
 
Back
Top