Data Validation

[Nate]

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

 

[cm]

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)

 

[Ms-Exl-Learner]

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

Menu>>Validation>>Settings>>Validation Criteria>>Allow>>Custom>> 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!