validation controls in excel

  • Thread starter harini 04B01A0503
  • Start date
H

harini 04B01A0503

Can I get a formula fr applyin a validation control on a cell which
accepts alphanumeric values with specified text length..its abit
urgent fr me..im new to this whole environment...
 
B

Bernie Deitrick

Use Data Validation with the Text Length option chosen, and set the Min and Max to the same value.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell validation 29
Multiple data validation criteria? 1
Mind-numbing simple data validation ... string from 1 to 64 chars 6
Dependent vlookups - nested vlookups (maybe) 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Problem with Vlookup and Data Validation 3
Data Validation blanks for formulas 18
MS Excel Data Validation, Ignore Blanks in List 4

Top