Hi,
1. how can i create custom Data Valitadation in cell to have only 3 signs, first as alphabetic and second and third as numbers from 0 to 99
Can you help please?
for example N06
2. Second issue is more difficult. I need DV list to have only 7 characters in cell, first has to be alphabetic letter, rest only digits, letters and underscore are allowed.
And i have to avoid empty spaces.
for example B33dv_1
Please help,
Best,
Jacek
Ad 1.
Data validation for cell (custom):
Formula:
Please Login or Register to view this content.
Last edited by KOKOSEK; 03-19-2019 at 07:35 AM.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
1. =and(left(a1,1)>="a",left(a1,1)<="z",right(a1,2)>="00",right(a1,2)<="99",len(a1)=3)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
It's not a good idea but you can try this generic formula. Just change the red part with any number that you want
1. (Post #3 is a better formula)
2.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by congnt92; 03-20-2019 at 03:06 AM. Reason: font color tag
@KOKOSEK
returns True if we have "#01" in A1Please Login or Register to view this content.
Thank you Guys, is working !
congnt92 wow thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks