Function Problems

Why TEXTJOIN Does Not Show All Excel Values in a Cell

Adam DavisAdam Davis Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Select the TEXTJOIN cell

Click the cell that contains your TEXTJOIN formula, such as =TEXTJOIN(",",TRUE,$A:$A).

2
Look at the formula bar

Check the formula bar above the worksheet to see more of the combined result than the cell displays.

3
Open the cell editor

Double-click the cell or press F2 to enter edit mode and move through the full text.

4
Paste as values for easier review

Copy the formula cell, right-click another cell, choose Paste Special > Values, and double-click the new cell to inspect the complete result.

View the Full TEXTJOIN Result in the Formula Bar or Cell Editor
Result is not lost: If the formula object contains the text, the cell content is still present even when the visible cell area appears truncated.
WPS Office solution

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. 1. Open the Excel file in WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the TEXTJOIN formula.
  2. 2. Select the TEXTJOIN cell: Click the cell with =TEXTJOIN(",",TRUE,$A:$A) and review the formula bar.
  3. 3. Use the formula bar or edit mode: Double-click the cell or press F2 to navigate through the full returned text.
  4. 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.
Full compatibility with Excel .xlsx and .xls files that contain TEXTJOIN formulas.Formula bar and cell editor make it easy to inspect long combined text.Lightweight and free spreadsheet tools for opening large workbooks quickly.Familiar Ribbon interface simplifies range selection and formula editing.
microsoft office alternative - wps office

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.