Lower/Upper Case

This example teaches you how to convert a text string to lower, upper or proper case in Excel.

1. Use the LOWER function to convert all letters in a text string to lowercase.



2. Use the UPPER function to convert all letters in a text string to uppercase.



3. Use the PROPER function to convert a text string to proper case. That is, the first letter in each word in uppercase, and all other letters in lowercase.

.