Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
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.
Also Read:
- 1. How to change all caps letters to lower case in Excel?
- 2. Top 10 Customizable business case template ppt free download
- 3. 10 Best Excel Test Case Templates: Useful Programs, Lists, and Material
- 4. 10 Business Case Template PPT: To Make a Presentation for Your Business
- 5. 10 Patient Case Presentation Templates: Beautifully Designed Templates for Doctors
- 6. 10 professional case study presentation examples of report templates