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