You can use the following basic formula to concatenate a range of cells with a comma in Google Sheets:

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

This particular example concatenates each cell in the range **A2:C2** with a comma in between the characters of each cell.

**Note**: The **TRUE** argument specifies that blank cells in the range should be ignored.

The following example shows how to use this formula in practice.

**Example: Concatenate Cells with a Comma in Google Sheets**

Suppose we have the following dataset in Google Sheets that contains the first, middle and last names of various people:

We can type the following formula into cell **D2** to concatenate the names in cells **A2** through **C2** with commas:

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

We can then copy and paste this formula down to each remaining cell in column D:

Notice that the first, middle and last names in each row have all been concatenated together in column D with commas separating each name.

Note that in the **TEXTJOIN** formula we intentionally added a space after each comma as well.

If you’d like, you can use the following formula to join the cells together with commas only:

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

The following screenshot shows how to use this formula in practice:

Notice that the first, middle and last names in each row have all been concatenated together with commas and no spaces.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Use a Concatenate If Formula

Google Sheets: How to Use CONCATENATE with a Space

Google Sheets: How to Use CONCAT with QUERY