Two validations in one Cell

[zargon]

Hi.

I'm a new user and i'm finding a solution for this case:

I need that in a one cell the user input only can write a string specifically of 7 or 10 characters, the values 1 to 6 and 8, 9, or greater than 10 are not valid, I tried to solve this with validation but i can't, i hope anyone can help me.

Thanks.

 

[mikerickson]

I'm confused about your requirements.

The string must be 7 or 10 characters in length (not 8 or 9)
The digit "7" must not be in the string. But, where (if anywhere) is the digit "0" allowed?

Are there any letters allowed in the string? If so, must they be at the start or end of the string or in specific positions?

 

[zargon]

Thanks for the answer Mike.
I need that the input only accept 7 or 10 characters, it doesn't matter if the string contains letters or numbers.

 

[Rick Rothstein]

I need that in a one cell the user input only can write a string specifically of 7 or 10 characters, the values 1 to 6 and 8, 9, or greater than 10 are not valid, I tried to solve this with validation but i can't, i hope anyone can help me.

For some reason, you did not tell us which cell you wanted this for, so I have assumed cell F1 (change as necessary). Use this Custom Data Validation Formula...

=(LEN(F1)=7)+(LEN(F1)=10)

 

[zargon]

[FONT=wf_segoe-ui_normal]Thank you so much Rick Rothstein sorry for omit specify the cell[/FONT][FONT=wf_segoe-ui_normal]... this works perfectly. I hope not to bother, one more question... what if i want personalize a messeage instead of a true or false values in the validation?[/FONT]

 

[Rick Rothstein]

[FONT=wf_segoe-ui_normal]...what if i want personalize a messeage instead of a true or false values in the validation?[/FONT]

I am not exactly sure what you mean by this... the validation must be a True/False result. You can craft the message that is displayed when the input is not 7 or 10 characters long though... is that what you meant? You would do that by clicking the "Error Alert" tab on the Validation dialog box and selecting the style of the message box as well as filling in the message box title and text to display.

 

[zargon]

Well, i tried with =IF(LEN(A4)=7,"OK","NO"), and this works for me... now i have some problems to validate the 2 cases like your previous answer =(LEN(F1)=7)+(LEN(F1)=10), but usuing the IF function to include "OK" or "NO" message...

 

[zargon]

Thanks for your valuable help Rick, i solved this little problem.

Regards.