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.

Lower Function in Excel

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

Upper Function in Excel

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.

Proper Function in Excel