How to Use the PROPER Function in WPS on Windows

Last updated:July 17, 2026

This section includes 1 how-to topic, covering how to use the PROPER function; open the How-to Index and follow the entry path and steps to capitalize each word in worksheet text.

How-to Index

No.TopicMembership Requirement
11. Use the PROPER FunctionFree

How-to Guide

1. Use the PROPER Function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want to enter the formula.
  2. Type = in the cell or formula bar to start the formula.
  3. Type PROPER( and review the syntax prompt and example.
  4. Enter a text value or a cell reference, such as =PROPER(A2).
  5. Press Enter to confirm and review the result in the cell.

Success Criteria

  • Interface result: The cell displays the converted text result.
  • What you can do next: You can fill the formula down or copy the result to another column.
  • No side effects: The original source column is not directly overwritten when you enter the formula in a new cell.

Tips While Using

  • Common mistake: If the formula does not start with =, it is treated as plain text.
  • Argument format: The argument should be text, a formula that returns text, or a cell reference containing text.
  • Result check: If the output is not what you expect, check the parentheses, the referenced cell, and the source text.