How to Add Comma in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023
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 two 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 use the ampersand operator (“&”) to merge the two cells and the comma together.

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

Add Comma to a List (Excel 2019 and Later)

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



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

In the example above, within the TEXTJOIN Function we first enter the comma as 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 replace one character with another. Here we will replace all spaces (” “) with commas (” ,”)

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


Here we replace the dash (-) with commas.



Create Running Lists with Commas

To create a running list with commas, use the following formula:


Running List

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

Add Commas in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

add comma Google Function

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List