UPPER, LOWER, PROPER to change text case in Excel

With inconsistent text, use functions to change the case of existing text. Since all of the following functions work the same, we’ll see how to use just one of them.

PROPER function – capitalizes the first letter in each word.

UPPER function – changes text to all uppercase.

LOWER function – changes text to all lowercase.