Setting Data Validation

  • Thread starter Thread starter Techtrainer
  • Start date Start date
T

Techtrainer

Can anyone tell me how, if possible, can I set up a data validation, such the
entry must star with a capital E and be followed by 3 numeric digits?

Thanks
Bill
 
I'm sure it can be done more elegantly but with A1 selected select Custom
from the Data Validation Allow drop down and paste this in:

=EXACT(LEFT(A1,1),"E")*(LEN(A1)=4)*NOT(ISERROR(RIGHT(A1,3)*2))

--
Jim
| Can anyone tell me how, if possible, can I set up a data validation, such
the
| entry must star with a capital E and be followed by 3 numeric digits?
|
| Thanks
| Bill
 
Back
Top