Data Validation - Restrict cell with multiple conditions

[hitarov]

Dear folks,

Much appreciate your help with below case:

Restrict cell A1 with 2 conditions:
- A1 must be alphanumeric
- Length must be < 19

I try OR(AND(CODE(A1)>=65,CODE(A1)<=90),AND(CODE(A1)>=97,CODE(A1)<=122),AND(CODE(A1)>=48,CODE(A1)<=57)) with the first condition but it seems like it only checks the first character of the cell.

Thank you very much.

 

[etaf]

try
ISNUMBER(SUMPRODUCT(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_")))

have a read here
http://www.mrexcel.com/forum/excel-...n-alphanumeric-other-specific-characters.html

to reduce len to 18

=AND(LEN(A1)<19,ISNUMBER(SUMPRODUCT(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_"))))

 

[hitarov]

It works, thanks a lot

 

[etaf]

your welcome