How To Add A Comma Between Names In Excel

Return to Excel Formulas List

How to Add Comma in Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to add commas in Excel and Google Sheets.

add comma main

Add Single Comma

To merge ii cells together with a comma between the cell values, use this formula:

Add Comma

In this example we've merged two cells together, separating the cell values with a comma. We apply the ampersand operator ("&") to merge the 2 cells and the comma together.

Note: When entering text into Excel formulas (in our case a comma), call up to surround the comma with quotations.

Add Comma to a List (Excel 2019 and Later on)

Commas tin also be added to lists in Excel and Google Sheets with the use of the TEXTJOIN Function.

=TEXTJOIN ( "," , TRUE , B3 : B6 )

Textjoin

The TEXTJOIN Function merely combines a range of cells together, separated by a delimiter (in our example a comma).

In the example above, inside the TEXTJOIN Function we commencement enter the comma equally the delimiter, next we choose to ignore blank cells by selecting "TRUE" and then we select the range to merge ("B3:B6").

The TEXTJOIN Function was introduced in Excel 2019.

Replace space by Comma

You can use the SUBSTITUTE Function to supplant one character with another. Here we will supplant all spaces (" ") with commas (" ,")

=SUBSTITUTE ( B3 , " " , " ," )

SUBSTITUTE

Hither nosotros replace the dash (-) with commas.

SUBSTITUTE Dash

Create Running Lists with Commas

To create a running list with commas, apply the post-obit formula:

Running List

The formula creates a list that keeps building for each row. Using the ampersand operator, the jail cell above is joined to the prison cell to the left.