WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change case in Excel

December 8, 2021
12.5K Views

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.

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.