Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CM CM is offline
external usenet poster
 
Posts: 136
Default 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