Custom validation to Allow only alphanumeric values with minimum 5 and maximum 10 characters.

0

I want the custom validation which will allow user ro enter the values given below:

abc10

abcde

asdasfaf

sdsdsdsds1

1234567890

123456789e

12345werty etc.

Answer
Discuss

Answers

0

Use a formula like this:

=NOT(OR(D2="abc10,D2=""abcde"))

Just follow the patter for all of the desired text that you want to allow and then enter the final formula into the data validation Custom section.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login