I would like to force user data to CAPS on enter as well as validate to limit A, B, C, and D.
I can validate with drop down; but when drop dn list appears, user can enter lower case of above and enter (doesn't force Upper).
I tried using =EXACT(A1,UPPER(A1)) with Data Validation Custom which forces entry to Upper -but unable to limit to A, B, C, and D.
Ideas? TIA
I can validate with drop down; but when drop dn list appears, user can enter lower case of above and enter (doesn't force Upper).
I tried using =EXACT(A1,UPPER(A1)) with Data Validation Custom which forces entry to Upper -but unable to limit to A, B, C, and D.
Ideas? TIA