How to Use the TRIM Function in WPS on Windows

Last updated:July 23, 2026

Use TRIM through 3 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry path and steps to complete the setup.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use TRIMFree
22. Review the parameter format and enter the formulaFree
33. Use a sample formula to clean textFree

How-to Guide

1. Create a formula field and use TRIM

Entry path: Add Field → Formula

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

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the formula and review the calculated result.

Tips While Using

  • Common mistake: If you do not choose the Formula field type first, you cannot enter the function directly.
  • Environment note: You need edit permission for the current table.

2. Review the parameter format and enter the formula

Entry path: Formula Editor → Function Library → TRIM

  1. Open the formula editor in an existing formula field.
  2. Open the function library and locate TRIM.
  3. Enter the argument by following the format shown in the editor.
  4. Check that parentheses, field references, and text content are complete.
  5. Save the formula and review the returned result.

Success Criteria

  • Interface result: The formula editor shows a complete TRIM expression.
  • Next action available: After saving, the field returns a cleaned text result.

Tips While Using

  • Common mistake: If parentheses are not closed or a field reference is incomplete, the formula may not calculate correctly.
  • Environment note: Field names must match the current table structure.

3. Use a sample formula to clean text

Entry path: Formula Field → Enter a sample formula

  1. Choose a text field that contains extra spaces.
  2. Enter a sample formula such as TRIM(Target Field) in the formula field.
  3. Save the formula.
  4. Compare the original field with the formula result.
  5. Reuse the cleaned result in other formulas or display fields if needed.

Success Criteria

  • Interface result: The formula field shows text with cleaner spacing.
  • Next action available: The cleaned result can be used in later field calculations.

Tips While Using

  • Common mistake: If the target field does not contain the expected text content, the result may differ from what you expect.
  • Environment note: The formula result updates automatically when the source field changes.