How to Use the CHAR Function in WPS on Windows

Last updated:July 23, 2026

This guide includes 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps to complete the setup.

How-to Index

No.TopicMembership
11. Create a formula field and call CHARFree
22. Review the parameter formatFree
33. Write and test a sample formulaFree

How-to Guide

1. Create a formula field and call CHAR

Entry path: Add Field → Formula

  1. Open the multidimensional 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 CHAR in the formula editor.
  5. Click Confirm to save and review the formula result.

Success Criteria

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

Tips While Using

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

2. Review the parameter format

Entry path: Formula Editor → Function Library → CHAR

  1. Open the formula editor in the multidimensional table.
  2. Go to the function library and find CHAR.
  3. Review the parameter format shown for the function.
  4. Enter the parameter by following the format required in the editor.

Success Criteria

  • Interface result: The formula editor shows the CHAR function name and parameter format.
  • Next action available: You can continue entering the full formula based on the format.

Tips While Using

  • Common mistake: If the parameter format is incomplete, the formula may not return the expected result.

3. Write and test a sample formula

Entry path: Formula Field → Formula Editor

  1. Enter a sample formula such as =CHAR(65) in the formula field.
  2. Change the parameter as needed to test different character results.
  3. If needed, combine CHAR with other functions in the same formula.
  4. Save the formula and check whether the result refreshes when data changes.

Success Criteria

  • Interface result: The formula field shows the corresponding character result.
  • Next action available: You can continue changing parameters or nesting other functions.

Tips While Using

  • Common mistake: If the parameter does not meet the function requirement, the result may return an error.
  • Environment note: Different data values can affect the final result of nested formulas.