How to Convert Excel Text to Lowercase or Proper Case in WPS Office Spreadsheets
Question details
The user needs to convert mixed-case text in a spreadsheet to all lowercase or capitalize the first letter of each word using Excel-compatible formulas.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a column of text with inconsistent capitalization and wants to normalize it to lowercase or title-style capitalization without retyping the values.
- Observed behavior
- Text values display mixed-case characters until a conversion formula is applied and the results are pasted over the source range.
Make sure the text you want to convert is in a recognizable text format, and use an empty helper column next to it for the formula results before replacing the original data.
Convert Text to Lowercase or Proper Case with LOWER and PROPER Formulas
Use this formula-based method when you need a repeatable way to normalize mixed-case text in a WPS spreadsheet without manually editing each cell.
The LOWER function returns every letter in lowercase, while PROPER capitalizes the first letter of each word. Both formulas leave the original cell unchanged until you paste the results over the source range.
Open your workbook in WPS Office Spreadsheets and click an empty cell next to the text you want to convert, such as B1.
Type =LOWER(A1) and press Enter to convert the text in A1 to all lowercase.
In another helper cell, type =PROPER(A1) and press Enter to capitalize the first letter of each word.
Select the helper cell, hover over the fill handle at its lower-right corner, and drag down to apply the formula to the remaining rows.
Copy the resulting helper cells, right-click the original range, choose Paste Special > Values, and confirm to replace the mixed-case text.
Convert Excel Text to Lowercase or Proper Case with WPS Office Spreadsheets
Use WPS Office Spreadsheets to apply LOWER and PROPER formulas, fill the results down a column, and paste values over the original range to normalize mixed-case text in an Excel-compatible workspace.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the mixed-case text you want to convert.
- 2. Apply the LOWER or PROPER formula: Click an empty helper cell, enter =LOWER(A1) or =PROPER(A1), and press Enter.
- 3. Fill down and replace the original values: Drag the fill handle down, copy the formula results, right-click the source range, and choose Paste Special > Values.
Frequently Asked Questions
What is the formula to convert text to lowercase in WPS Office Spreadsheets?
Use =LOWER(A1), where A1 is the cell with the original text. This returns the text in all lowercase.
How do I capitalize the first letter of each word in WPS Spreadsheets?
Use =PROPER(A1). It converts mixed-case text to title-style capitalization where each word starts with an uppercase letter.
How do I replace the original text with the converted values instead of keeping helper formulas?
Select and copy the formula results, right-click the original range, choose Paste Special > Values, and confirm. You can then delete the helper column.
Can I apply LOWER or PROPER to an entire column at once?
Yes. Enter the formula in the first helper cell, then drag the fill handle down or double-click it to fill the formula to the remaining rows.
Do these formulas work with .xlsx files from Microsoft Excel?
Yes, WPS Office Spreadsheets supports LOWER and PROPER formulas and is compatible with Excel .xlsx files.
