How to Use the TEXTJOIN Function in WPS on Windows

Last updated:July 23, 2026

There are 3 how-to topics for using TEXTJOIN, and all 3 are available without membership: creating a formula field, entering parameters, and checking example results.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call TEXTJOINFree
22. Enter the TEXTJOIN parameter formatFree
33. Check example results and automatic refreshFree

How-to Guide

1. Create a formula field and call TEXTJOIN

Entry point: Add Field → Formula

  1. Open the WPS multi-dimensional table that you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes TEXTJOIN in the formula editor.
  5. Click Confirm to save the setting.

Success Criteria

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

Tips While Using

  • You need permission to edit fields in the current multi-dimensional table.
  • After saving, the formula starts calculating immediately, so it is helpful to confirm field references first.

2. Enter the TEXTJOIN parameter format

Entry point: Formula Editor → Enter function parameters

  1. Type TEXTJOIN in the formula editor.
  2. Enter the parameters in the required function format.
  3. Add the target data range or text content as needed.
  4. Check whether the delimiter and parameter order match your expected result.
  5. Save the formula and return to the table to review the output.

Success Criteria

  • Interface result: The full TEXTJOIN formula is visible in the editor.
  • Next action available: After saving, you can review the joined result in the record.

Tips While Using

  • If the parameter format is incorrect, the result may not display normally.
  • Before entering the formula, confirm whether you are joining text fields or other field content.

3. Check example results and automatic refresh

Entry point: Formula field result area

  1. Enter an example formula in the formula field.
  2. Save it and review the calculated result in the current record.
  3. Change the content in the referenced source field.
  4. Return to the formula field and confirm that the result updates accordingly.

Success Criteria

  • Interface result: The formula field shows the joined text result.
  • Next action available: After source data changes, the result refreshes accordingly.

Tips While Using

  • If the result does not update, first check whether the formula references the correct fields.
  • The displayed result depends on the actual data in the current record.