How do I restrict entry into a cell to only alpha/numeric?
I'm already using the data validation on this cell to restrict the length.
Can that be incorporated into this formula too? Also, where can I find
information on adjusting the codes to match my needs?
"Stefi" wrote:
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 -.
|