How to change case in Excel

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.

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.

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.

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