Data Validation

  • Thread starter Thread starter CTC
  • Start date Start date
C

CTC

I am trying to apply validation to a range of cells which must be both 12
characters in length as well as in upper case to be accepted.

Can anyone help

Please
 
I assume you want *only* the uppercase characters A - Z. No numbers, no
spaces, no punctuation characters.

=AND(LEN(A1)=12,SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("65:90"))),"")))=LEN(A1))
 
Still not sure what to do. If I have a range say b2:b345 all data entered
must be 12 characters in lenght and any alpha characters myst be in capitals
what do I need to enter and where do I enter it?
 
Since you mentioned validation Biff probably assumed you knew the basics.
Replace A1 in the formula he gave you with B2, then select B2:B345 with B2
as the active cell,
that will happen if you start selecting from B2, then do
data>validation>allow>custom and put the formula there.


--


Regards,


Peo Sjoblom
 
Back
Top