Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
64
Views
Topic starter
Hi to all 🙂
I have made a great work on "how to restrict different characters within a Cell".
But i face difficulty with data validation?
Please attached you have the file.
Best Regards,
Dritan
Posted : 22/07/2017 8:32 am
Hi Dritan
I believe the length of your formula is too long (286 characters including the = sign).
As far as I know, for Data Validation the maximum length is 255.
I have created a shorter formula for you. I have tested it and it looks OK.
Hope this helps.
Sunny
Posted : 22/07/2017 10:53 pm
Topic starter
Thank you for your help,
You have use a very smart way to solve 🙂
Posted : 25/07/2017 2:44 am
