View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aditya Aditya is offline
external usenet poster
 
Posts: 54
Default multiple data validation

i want to do 2 data validation at a time for same cell e.g.

(1)text length should be exactly 10
(2)First two letter should be either of 'NW" OR "UP" OR "DN"
(3)Next two letter be either of "NR" OR "WR"
(4)Rest 6 can be anything

e.g. UPWR123421
DNWR12/345