Combine Excel Column Values into a Comma-Separated List
Question details
Combine values from a column range into one comma-separated cell while ignoring blank cells.

- 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.
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.
Use TEXTJOIN to combine values and skip blanks
Use this formula to create a comma-separated list that updates when the source cells change.
Click an empty cell outside A1:A5 where you want the combined list to appear.
Type =TEXTJOIN(",",TRUE,A1:A5) in the cell or formula bar, then press Enter.
Edit A1:A5 in the formula to use another range. Replace "," with ", " to add a space after each comma.

Use Excel for the web if desktop Excel lacks TEXTJOIN
Open the workbook in Excel for the web when your desktop version does not support the function.
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. Open the workbook: Launch WPS Office and open your workbook in WPS Spreadsheets.
- 2. Choose a destination: Click an empty cell outside the range you want to combine.
- 3. Enter TEXTJOIN: Type =TEXTJOIN(",",TRUE,A1:A5) in the destination cell and press Enter.
- 4. Customize the list: Edit the range in the formula as needed, or change the delimiter to ", " for spaces after commas.

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.




