How do I use the Excel Formula To Join Cells Into One Cell formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Join cells into one cell with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join cells into one cell.

ExcelGoogle SheetsWPS

=TEXTJOIN(", ", TRUE, A2:D2)

Join cells with commas with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join cells with spaces with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join cells with a dash with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join cells with a slash with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join columns with commas with a ready-to-use formula for Excel, Google Sheets, and WPS.

Join columns with spaces with a ready-to-use formula for Excel, Google Sheets, and WPS.