How to Use the UPPER Function in WPS on Windows

Last updated:July 20, 2026

Use the UPPER function through 3 how-to topics in WPS Spreadsheets; 3 items are available without membership and 0 items are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter the UPPER functionFree
22. Convert referenced cell text to uppercaseFree
33. Use syntax prompts while entering the formulaFree

How-to Guide

1. Enter the UPPER function

Entry point: Formula bar or target cell

  1. Open WPS Spreadsheets and select the cell where you want to display the result.
  2. Type = to start the formula.
  3. Type UPPER(.
  4. Enter the text you want to convert and complete the closing parenthesis.
  5. Press Enter to confirm and view the result.

Success Criteria

  • Interface result: The target cell displays the converted uppercase text.
  • Next action available: You can continue editing the formula or fill it into other cells.

Tips While Using

  • Common mistake: If you do not start with =, the content is treated as plain text.
  • Environment note: You need to enter the formula in an editable cell.

2. Convert referenced cell text to uppercase

Entry point: Formula bar or target cell

  1. Select a blank cell for the result.
  2. Type =UPPER(.
  3. Click or type the cell reference that contains the original text.
  4. Type the closing parenthesis ).
  5. Press Enter to confirm the result.

Success Criteria

  • Interface result: The result cell shows the uppercase version of the referenced text.
  • Next action available: When the original cell changes, the result can update accordingly.

Tips While Using

  • Common mistake: If you reference a blank cell, the result may also be blank.
  • Environment note: The original data should be text that the function can process.

3. Use syntax prompts while entering the formula

Entry point: Formula bar

  1. Select the target cell and type =.
  2. Type UPPER(.
  3. Check the syntax prompt shown by the app.
  4. Complete the parameter based on the prompt.
  5. Press Enter to finish the formula.

Success Criteria

  • Interface result: Function prompt information appears while you are entering the formula.
  • Next action available: You can continue adjusting the parameter and confirm again if needed.

Tips While Using

  • Common mistake: If the parentheses are incomplete, the formula may not return the expected result.
  • Environment note: Syntax prompts are visible while you are in formula entry mode.