Data Validation
 

Is there any way, using data validation, to require the value entered in a
cell to start with the letter "H" and contain a total of 5 characters?
Thanks,

Nate
XL2003

Data Validation
 

for cell G13: use the 'Custom' option in the data validation and on the
formula line put:

=AND(LEFT(G13, 1) ="H",LEN(G13) <=5)

"Nate" wrote:

Is there any way, using data validation, to require the value entered in a
cell to start with the letter "H" and contain a total of 5 characters?
Thanks,

Nate
XL2003

Data Validation
 

Nate wrote:
Is there any way, using data validation, to require the value entered in a
cell to start with the letter "H" and contain a total of 5 characters?
Thanks,

Nate
XL2003

Suppose Data Validation in Cell F4
Formula is =AND(LEFT(F4,1)="H",LEN(F4)=5)

--
Message posted via http://www.officekb.com

Data Validation
 

Try this...

=AND((LEN(A1)=5),(LEFT(A1,1)="H"))

Place the cursor in a1 cell and select the whole A column then click Data

MenuValidationSettingsValidation CriteriaAllowCustom and in
Formula paste the above formula.

Change cell reference a1 to your desired cell. But at the same time dont
forget to keep the cursor in activecell of your desired (cell) reference.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Nate" wrote:

Is there any way, using data validation, to require the value entered in a
cell to start with the letter "H" and contain a total of 5 characters?
Thanks,

Nate
XL2003