TEXTJOIN in WPS on Windows: Introduction

TEXTJOIN is a formula-field function in WPS multi-dimensional tables for joining multiple text values with a chosen delimiter; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks are available directly
Version restriction	None	Available in WPS multi-dimensional tables across versions

About This Feature

Overview

TEXTJOIN is a text-joining function used in formula fields in WPS multi-dimensional tables. It is suitable for combining multiple text values into one result string inside a record. To use it, add a field, choose Formula, enter a TEXTJOIN formula in the editor, and save it. The result appears in the corresponding record immediately.

Core tasks include:

Create a formula field and call TEXTJOIN.
Enter the required TEXTJOIN parameters and complete text joining.
Review the result from an example formula and let the output refresh when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	A network connection is recommended for download, installation, and sign-in; local editing after installation has no strict requirement
Other	You need access to WPS multi-dimensional tables and permission to edit fields in the current table

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multi-dimensional table, and confirm that you can add a Formula field and open the formula editor

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS multi-dimensional tables, TEXTJOIN can be entered in a formula field to join multiple text values with a chosen delimiter and show the result in each record automatically.	Excel provides the TEXTJOIN function to combine text with a delimiter and includes an option to ignore empty cells.	Google Sheets provides the TEXTJOIN function to combine strings or text from cell ranges.	Notion formulas support text operations such as join and concat in database formulas, but this is not a spreadsheet cell function.	Acrobat supports calculated form fields that update field results automatically, but it does not provide a direct table-style TEXTJOIN equivalent for text joining.
WPS Advantages	Advantage: TEXTJOIN can be used directly in formula fields for multi-dimensional table records, and results refresh with source data updates.	Compared with WPS: Excel TEXTJOIN is designed for spreadsheet cell workflows, so its data structure differs from record-based formula fields.	Compared with WPS: Sheets focuses on worksheet cell calculations rather than formula setup for multi-dimensional table records.	Compared with WPS: Notion can achieve similar text combinations, but its formula style and data structure differ from table-function syntax.	Compared with WPS: Acrobat calculation features are mainly for PDF forms rather than multi-dimensional table or spreadsheet text-joining workflows.
Official Source	—	TEXTJOIN function	TEXTJOIN	Formula syntax	Set calculation fields

Overall Conclusion

If your work is built around record fields in WPS multi-dimensional tables, TEXTJOIN fits directly into a formula-field workflow and works well for contact details, tag strings, or combined description fields. Excel and Google Sheets provide direct equivalents in spreadsheet function scenarios, while Notion and Adobe are closer alternatives for adjacent use cases rather than the same table-function experience.

Use Cases

No.	Scenario	Suitable for	Main issue	How TEXTJOIN helps
1	Combine names and departments	Team managers	Information is split across multiple fields and is hard to read quickly	Use TEXTJOIN in a formula field to combine names, departments, and other text
2	Build tag strings	Project collaborators	Multiple tag fields need to be shown in one place	Use a delimiter to combine several text values into one result
3	Generate description fields	Data coordinators	A record description needs to be assembled from multiple fields automatically	Use TEXTJOIN to create a consistent description string

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
TEXTJOIN function usage	✅ Available	✅ Available
Basic editing for formula fields in multi-dimensional tables	✅ Available	✅ Available
Other membership-related benefits	Shown according to the current account plan	Refer to the current plan details

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily use of TEXTJOIN in multi-dimensional tables	Free	This function has no membership restriction and can be used directly in a formula field
Reviewing broader account benefits	Check plans as needed	If you want to compare more suite benefits, review the current plan details on the pricing page

WPS membership page: Subscribe
Official download page: Download WPS Office