Function Problems

Combine Excel Column Values into a Comma-Separated List

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

Combine values from a column range into one comma-separated cell while ignoring blank cells.

Combine Excel Column Values into a Comma-Separated List
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to join the values in cells A1:A5 into a single list and adjust the formula for other ranges.
Observed behavior
The desired result is one cell containing the nonblank values separated by commas.
Before you start

Identify the range containing your values and choose an empty destination cell outside that range. Check that your Excel version supports TEXTJOIN; Excel for the web is an option if your desktop version does not.

Solution 1Recommended

Use TEXTJOIN to combine values and skip blanks

Use this formula to create a comma-separated list that updates when the source cells change.

1
Select the destination cell

Click an empty cell outside A1:A5 where you want the combined list to appear.

2
Enter the formula

Type =TEXTJOIN(",",TRUE,A1:A5) in the cell or formula bar, then press Enter.

3
Adjust the range or separator

Edit A1:A5 in the formula to use another range. Replace "," with ", " to add a space after each comma.

Use TEXTJOIN to combine values and skip blanks
Blank cells: The TRUE argument tells TEXTJOIN to ignore empty cells.
WPS Spreadsheets

Create a comma-separated list in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and use TEXTJOIN, where supported, to combine a range into one cell while skipping blanks.

  1. 1. Open the workbook: Launch WPS Office and open your workbook in WPS Spreadsheets.
  2. 2. Choose a destination: Click an empty cell outside the range you want to combine.
  3. 3. Enter TEXTJOIN: Type =TEXTJOIN(",",TRUE,A1:A5) in the destination cell and press Enter.
  4. 4. Customize the list: Edit the range in the formula as needed, or change the delimiter to ", " for spaces after commas.
Join column values with a comma or a comma and spaceSkip blank cells with the TRUE argumentOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I add a space after each comma?

Use =TEXTJOIN(", ",TRUE,A1:A5). The space inside the delimiter appears after each comma.

Will the list update when the source cells change?

Yes. The TEXTJOIN formula recalculates as values in its referenced range change.

What can I do if Excel does not recognize TEXTJOIN?

Your desktop version may not support the function. Open the workbook in Excel for the web, enter the formula there, and copy the result if needed.

How can I keep the list without the formula?

Copy the result cell, then use Paste Values at the destination to paste the displayed text instead of the formula.