I am trying to create a data validation rule for NAME attribute. My conditions are::
1. it should be text and may also contain "." and space.
2. length of name should be greater than 5 but less than 85 characters
3. the cell should not be blank
I have created a validation rule, but when I insert text of length greater 5 say 6 or 10 its showing error. I think my rule is mistake. Please help!
It is not working as expected.
IF(ISTEXT(B2),AND(LEN(B2)>=5,LEN(B2)<=85),B2=".")
Please try
=AND(ISTEXT(B2),LEN(B2)>=5,LEN(B2)<=85,ISNUMBER(FIND(".",B2)))
With this formula, I have to enter "." in every entry. But I need "." as optional value i.e. Jone kim and Jonie. kim both should be valid entry. How can I do this? Thank You!!!Originally Posted by Bo_Ry
Last edited by jone kim; 03-12-2019 at 05:14 AM. Reason: added
remove the find("."
=AND(ISTEXT(B2),LEN(B2)>=5,LEN(B2)<=85)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks