Capitalizing Text
Another way could be to use Data Validation, with a Custom formula
=EXACT(A1,UPPER(A1))
which will prevent any lowercase entry.
Well, except for a user who Copies/Pastes any text containing lowercase
characters into one of the cells with the validation formula you proposed.
Rick
|