I want the custom validation which will allow user ro enter the values given below:
abc10
abcde
asdasfaf
sdsdsdsds1
1234567890
123456789e
12345werty etc.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Custom validation to Allow only alphanumeric values with minimum 5 and maximum 10 characters.
0
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.