Lower/Upper Case values in Excel

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.