WPS Features
Resources
Free AI Tools
Docs Center

How to Use the PROPER Function in WPS on Windows

Last updated:July 13, 2026

Use the PROPER function with 3 how-to topics, all available without membership; choose a topic from the index and follow the steps to enter, review, or confirm the formula.

How-to Index

No.TopicMembership Requirement
11. Enter PROPER from the Insert Function dialog boxFree
22. Type the PROPER formula directly in a cellFree
33. Review PROPER syntax and parameter detailsFree

How-to Guide

1. Enter PROPER from the Insert Function dialog box

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for PROPER in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter the text value or cell reference in the Function Arguments dialog box.
  6. Click OK to finish.

Success Criteria

  • The selected cell now contains a PROPER formula.
  • After confirmation, the result appears with the first letter of each word capitalized.
  • You can continue by copying the formula or filling it down to other cells.

Tips While Using

  • Use the English function name PROPER when searching.
  • You can reference another cell as the argument for batch processing across a column.

2. Type the PROPER formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =PROPER(...) directly in the cell or in the formula bar.
  3. Enter the text value or target cell reference inside the parentheses.
  4. Press Enter to confirm.

Success Criteria

  • The cell shows the calculated result instead of plain formula text.
  • The result displays each word with an uppercase first letter.
  • When you select the cell again, the full formula is visible in the formula bar.

Tips While Using

  • The formula must begin with an equals sign =.
  • If you reference another cell, the result updates when the source cell content changes.

3. Review PROPER syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Type PROPER in the search box.
  3. Select the function and review the syntax and parameter area.
  4. If the interface provides a related help entry, open it for more details.

Success Criteria

  • You have opened the PROPER function information area.
  • You can review the function name, syntax format, and parameter input area.
  • You can continue with formula entry or adjustment based on that information.

Tips While Using

  • Reviewing the syntax first can reduce parameter entry mistakes.
  • If the result is not what you expect, check whether the referenced content is the intended text.