How to Use the UPPER Function in WPS on Windows

Last updated:July 23, 2026

Use UPPER through 3 how-to topics, with 3 available without membership and 0 membership-related items; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use UPPERFree
22. Check the parameter format and enter it correctlyFree
33. Use the UPPER result in recordsFree

How-to Guide

1. Create a formula field and use UPPER

Entry path: Add Field → Formula

  1. Open the multidimensional table you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes UPPER in the formula editor.
  5. Click Confirm to save the setting.

Success Criteria

  • On-screen result: A new formula field appears in the table.
  • Next action available: You can view the calculated result in that field.

Tips While Using

  • Common mistake: Selecting a regular text field instead of a formula field.
  • Environment note: You need permission to edit the current table structure.

2. Check the parameter format and enter it correctly

Entry path: Formula Editor → Function Library → UPPER

  1. Open the function library in the formula editor.
  2. Select UPPER to review its format.
  3. Enter the parameter in the UPPER(text) format.
  4. Check whether the referenced content is text or can be converted to text.
  5. Save the formula and return to the table.

Success Criteria

  • On-screen result: The formula editor no longer shows a format error.
  • Next action available: The field displays the uppercase result after saving.

Tips While Using

  • Common mistake: Missing brackets, quotation marks, or field reference syntax.
  • Environment note: If you reference another field, confirm that the field name is available.

3. Use the UPPER result in records

Entry path: Formula result column

  1. Enter or update the original text in an existing record.
  2. Check the UPPER result in the formula field.
  3. Confirm that the text has been converted to uppercase.
  4. Continue editing the source field and watch the result refresh.

Success Criteria

  • On-screen result: The formula field shows uppercase text.
  • Next action available: The result updates automatically after source data changes.

Tips While Using

  • Common mistake: Trying to type directly into the calculated result column.
  • Environment note: Formula fields are calculated result columns and usually are not edited directly.