How to Use Lower/Upper Case In Excel

Oct 31, 2020 • edited Nov 03, 2020

How to Use Lower/Upper Case 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.

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

#Tutorial#How To#Functions

How to Use Locate Maximum Value In Excel

How to Use MaxIfs and MinIfs Function In Excel