How do I restrict entry into a cell to only alpha/numeric?
Apply this formula in Data/Validation/Custom and adjust it to your
requirements as far as upper and lower case and additional characters are
concerned:
=OR(AND(CODE(B3)=65,CODE(B3)<=90),AND(CODE(B3)=9 7,CODE(B3)<=122),AND(CODE(B3)=48,CODE(B3)<=57))
Regards,
Stefi
€˛SusanMurray€¯ ezt Ć*rta:
How do I restrict entry into a cell to only alpha/numeric? I don't want
characters. Or maybe just limited characters like -.
|