How to change case in Excel
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula