How to Use the RIGHT Function in WPS on Windows

Last updated:July 23, 2026

Use the RIGHT function with 3 how-to topics, all available without membership; start from the How-to Index and follow the entry path and steps for each task.

How-to Index

No.TopicMembership
11. Create a formula field and enter RIGHTFree
22. Fill in RIGHT parameters with the correct syntaxFree
33. Combine RIGHT with other formulasFree

How-to Guide

1. Create a formula field and enter RIGHT

Entry path: Add Field → Formula

  1. Open the data table you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter RIGHT in the formula editor.
  5. Continue with the parameters and save the formula.

Success Criteria

  • Interface result: A formula field is added and the formula editor is open.
  • Next action available: You can continue entering parameters, save the formula, and view the calculated result.

Tips While Using

  • Common mistake: If you do not choose the Formula field type first, you cannot enter a formula function correctly.
  • Environment note: You need permission to edit fields in the current table.

2. Fill in RIGHT parameters with the correct syntax

Entry path: Formula Editor → Formula Input Area

  1. Enter RIGHT( in the formula editor.
  2. Add the target text or field as the first parameter.
  3. Add the number of characters you want as the second parameter.
  4. Check that brackets and separators are complete.
  5. Confirm and save the formula.

Basic syntax:

RIGHT(text, number_of_characters)

Success Criteria

  • Interface result: The formula saves successfully without a syntax error.
  • Next action available: The field shows the extracted text result.

Tips While Using

  • Common mistake: If the parameter order is wrong, the result may not match your expectation.
  • Common mistake: If the character count is not suitable, the returned text may be too short or too long.

3. Combine RIGHT with other formulas

Entry path: Formula Editor → Combined Formula Input

  1. Open an existing formula field or create a new one.
  2. Enter a combined formula that includes RIGHT.
  3. Add other functions or conditions based on your rule.
  4. Preview the returned result.
  5. Save the formula and check whether records refresh automatically.

You can extend the formula based on your current field rules and use the result of RIGHT as the input for another formula.

Success Criteria

  • Interface result: The combined formula is saved successfully and the field result displays normally.
  • Next action available: When source data changes, the formula result updates accordingly.

Tips While Using

  • Common mistake: It is easy to miss a bracket in nested formulas.
  • Environment note: Test complex formulas on a small set of records first.