Return to Excel Formulas List

Combine Cells With Comma – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to combine cells with a comma in Excel and Google Sheets.

combine-cells comma Main Function

TEXTJOIN Function

You can combine cells with a comma using the TEXTJOIN function.  The TEXTJOIN function is available in Office 365 and Office 2019.

combine cells comma TEXTJOIN

You enter the delimiter into the formula that you want to use to separate the information – in the case above, we are using a comma.

“TRUE” is used in the second argument to indicate that blank cells should be excluded from the result.

You can then specify the range of cells from where you want to obtain the data ex: B3:D3.

 

CONCAT Function

You can also combine cells with a comma by using the CONCAT Function. This older function is not as efficient as the new TEXTJOIN function as you must enter the comma’s directly into the formula each time you want them to appear.

“Note To Steven Please help to  Insert Below CONCAT function to Code Block”

 

combine cells comma CONCAT

 

Text Combine Method

A third way of combining cells with a comma is to use a simple text combine method.  This is also more laborious than the TEXTJOIN function but may be necessary use if you are using an older version of Excel.

combine cells comma AND

This formula uses the ampersand (&) to create a text string using the cell addresses and the comma contained within a text string.

Combine Cells with Comma in Google Sheets

All the above Excel examples work the same way in Google Sheets.

combine cells comma Google Function