Proper, Upper, Lower

The Proper, Upper, and Lower functions in Excel are functions that allow you to change the case of the text in one or more selected cells. Each function is unique in its capitalization. The Lower function changes the case of the text to all lowercase. The Upper function changes the case of the text to all uppercase. Lastly, the Proper function sets the first letter of each word to uppercase and the rest of the letters to lowercase. As you might imagine, these can be quite useful in a variety of situations.