If all letters are UPPER CASE this will work:
Formula:
=AND(CODE(MID(A1,1,1))>=65,CODE(MID(A1,1,1))<=90,CODE(MID(A1,2,1))>=65,CODE(MID(A1,2,1))<=90,CODE(MID(A1,3,1))>=65,CODE(MID(A1,3,1))<=90,CODE(MID(A1,4,1))>=65,CODE(MID(A1,4,1))<=90,CODE(MID(A1,5,1))>=65,CODE(MID(A1,5,1))<=90,CODE(MID(A1,6,1))>=48,CODE(MID(A1,6,1))<=57,CODE(MID(A1,7,1))>=48,CODE(MID(A1,7,1))<=57,CODE(MID(A1,8,1))>=48,CODE(MID(A1,8,1))<=57,CODE(MID(A1,9,1))>=48,CODE(MID(A1,9,1))<=57,CODE(RIGHT(A1,1))>=65,CODE(RIGHT(A1,1))<=90)
If the letters are lower case then this will work:
Formula:
=AND(CODE(MID(A1,1,1))>=97,CODE(MID(A1,1,1))<=122,CODE(MID(A1,2,1))>=97,CODE(MID(A1,2,1))<=122,CODE(MID(A1,3,1))>=97,CODE(MID(A1,3,1))<=122,CODE(MID(A1,4,1))>=97,CODE(MID(A1,4,1))<=122,CODE(MID(A1,5,1))>=97,CODE(MID(A1,5,1))<=122,CODE(MID(A1,6,1))>=48,CODE(MID(A1,6,1))<=57,CODE(MID(A1,7,1))>=48,CODE(MID(A1,7,1))<=57,CODE(MID(A1,8,1))>=48,CODE(MID(A1,8,1))<=57,CODE(MID(A1,9,1))>=48,CODE(MID(A1,9,1))<=57,CODE(RIGHT(A1,1))>=97,CODE(RIGHT(A1,1))<=122)
Both of these formulae check character by character the code number for each character to see if it falls between the values for upper or lower letters and numerals.
This is a combination of the two above but will not allow a mix of upper and lower case:
Formula:
=OR(AND(CODE(MID(A1,1,1))>=65,CODE(MID(A1,1,1))<=90,CODE(MID(A1,2,1))>=65,CODE(MID(A1,2,1))<=90,CODE(MID(A1,3,1))>=65,CODE(MID(A1,3,1))<=90,CODE(MID(A1,4,1))>=65,CODE(MID(A1,4,1))<=90,CODE(MID(A1,5,1))>=65,CODE(MID(A1,5,1))<=90,CODE(MID(A1,6,1))>=48,CODE(MID(A1,6,1))<=57,CODE(MID(A1,7,1))>=48,CODE(MID(A1,7,1))<=57,CODE(MID(A1,8,1))>=48,CODE(MID(A1,8,1))<=57,CODE(MID(A1,9,1))>=48,CODE(MID(A1,9,1))<=57,CODE(RIGHT(A1,1))>=65,CODE(RIGHT(A1,1))<=90),AND(CODE(MID(A1,1,1))>=97,CODE(MID(A1,1,1))<=122,CODE(MID(A1,2,1))>=97,CODE(MID(A1,2,1))<=122,CODE(MID(A1,3,1))>=97,CODE(MID(A1,3,1))<=122,CODE(MID(A1,4,1))>=97,CODE(MID(A1,4,1))<=122,CODE(MID(A1,5,1))>=97,CODE(MID(A1,5,1))<=122,CODE(MID(A1,6,1))>=48,CODE(MID(A1,6,1))<=57,CODE(MID(A1,7,1))>=48,CODE(MID(A1,7,1))<=57,CODE(MID(A1,8,1))>=48,CODE(MID(A1,8,1))<=57,CODE(MID(A1,9,1))>=48,CODE(MID(A1,9,1))<=57,CODE(RIGHT(A1,1))>=97,CODE(RIGHT(A1,1))<=122))
Bookmarks