How to change case in Excel

December 8, 2021
2,818 Views 0

There are three relevant functions can help a lot. Here we take a name table as an example.


1. UPPER function

We can use this function to convert the whole word to upper case. Enter the formula =UPPER(A2), and drag the mouse to fill the following cells.

How to change case in Excel1.gif  

2. LOWER function

We can use this function to convert the whole word to lower case. Enter the formula =LOWER(B2), and drag the mouse to fill the following cells.

How to change case in Excel2.gif 

3. PROPER function

We can use this function to convert the first letter to upper case. Enter the formula =PROPER(A2), and drag the mouse to fill the following cells.

How to change case in Excel3.gif  

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Was this helpful?