In one of my documents, I am using a data validation list to require selection from a pre-defined list. That part is easy enough.

However, if the user enters a matching value in lower or mixed case, I want the spreadsheet to automatically convert it to uppercase, which is the standard used in the defined list. I don't want to prompt the user with an error if the case is wrong; I'd like this spreadsheet to be smart enough to convert it automatically.

VBA is not an option on this document; I have to be able to do it with data validation only.

Is this possible? I've tried combinations of =UPPER(=ListName) in the custom formula field under Data Validation, but I'm not getting it to accept my formula.


dt