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
|