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

Do you like this free website? Please follow us on Google+