Why TEXTJOIN Does Not Show All Excel Values in a Cell
Question details
The user wants to understand why a TEXTJOIN formula does not visually show every combined value in a cell and how to access or manage the full result.
- Product
- WPS Office Spreadsheets (Excel)
- Device & OS
- not provided
- Scenario
- A user combines many text values with TEXTJOIN and expects the entire concatenated result to be visible in one cell.
- Observed behavior
- The cell shows only part of the long TEXTJOIN result even though the formula may still contain additional text.
Click the TEXTJOIN formula cell and check the formula bar to confirm whether the full combined text is still present beyond the visible cell area.
View the Full TEXTJOIN Result in the Formula Bar or Cell Editor
Use this when the TEXTJOIN formula is correct but the cell rectangle only displays part of a long result.
Excel cells can contain up to 32,767 characters, but the visible area of a cell only shows a portion of a long result. The formula bar and edit mode give you a way to inspect the complete returned text.
Click the cell that contains your TEXTJOIN formula, such as =TEXTJOIN(",",TRUE,$A:$A).
Check the formula bar above the worksheet to see more of the combined result than the cell displays.
Double-click the cell or press F2 to enter edit mode and move through the full text.
Copy the formula cell, right-click another cell, choose Paste Special > Values, and double-click the new cell to inspect the complete result.

Split TEXTJOIN Results Across Multiple Cells When the Text Exceeds 32,767 Characters
Use this when the combined output is longer than Excel's per-cell content limit and cannot be fully stored in one cell.
View and Manage Long TEXTJOIN Results in WPS Office Spreadsheets
Open your Excel workbook in WPS Office Spreadsheets, use the same TEXTJOIN formula, view the full result in the formula bar, and split large ranges if the output exceeds the cell character limit.
- 1. Open the Excel file in WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the TEXTJOIN formula.
- 2. Select the TEXTJOIN cell: Click the cell with =TEXTJOIN(",",TRUE,$A:$A) and review the formula bar.
- 3. Use the formula bar or edit mode: Double-click the cell or press F2 to navigate through the full returned text.
- 4. Split the range if necessary: If the result exceeds 32,767 characters, create smaller TEXTJOIN formulas such as =TEXTJOIN(",",TRUE,$A$1:$A$1000) across multiple cells.

Frequently Asked Questions
Why does my TEXTJOIN formula show only part of the result in the cell?
A cell's visible area is smaller than its content capacity. TEXTJOIN can return up to 32,767 characters, but the cell only displays what fits within the current row height and column width. Select the cell and check the formula bar or double-click the cell to see the rest.
What is the maximum number of characters a TEXTJOIN result can return in one cell?
A single cell can contain up to 32,767 characters. If TEXTJOIN returns more than that, the extra text cannot be stored in that cell and the source range must be split.
How do I view all values returned by TEXTJOIN without changing the formula?
Select the formula cell and look in the formula bar, press F2 to enter edit mode, or copy the cell and paste it as values into another cell, then double-click the new cell to review the full text.
What can I do when my TEXTJOIN result exceeds the Excel cell character limit?
Divide the source range into smaller parts and create separate TEXTJOIN formulas for each part, such as =TEXTJOIN(",",TRUE,$A$1:$A$1000), placing each result in a different cell.
Does WPS Office support TEXTJOIN?
Yes. WPS Office Spreadsheets supports TEXTJOIN and opens Excel files with the formula, so you can use the same syntax and view or edit the results in the formula bar.




