Data Validation – ALL CAPS
One use for Data Validation is to force the user to enter all capital letters. Use the Custom option and set up the Validation like this

Daily posts of Excel tips…and other stuff
One use for Data Validation is to force the user to enter all capital letters. Use the Custom option and set up the Validation like this
