In this article:

CONCATENATE Google Sheets: The Ultimate Guide [2024]

If you need to combine information from different cells in Google Sheets, manually rewriting each data entry in one cell is time consuming and frustrating. Fortunately, the Google Sheets CONCATENATE function allows you to easily combine multiple cells, even separating their contents with commas or semicolons.

What is the Google Sheets CONCATENATE Function?

The CONCATENATE function allows you to effortlessly combine the contents of cells or individual strings into one string in one cell in Google Sheets. The best part is that you can apply it quickly to large amounts of data, preventing you from having to manually merge each entry.

Although CONCAT and CONCATENATE are similar functions, CONCAT is very limited. It does not allow you to add delimiters, and you cannot combine more than two cells or strings. Therefore, CONCATENATE is much more practical and functional, and we will cover all of its many uses in this article.


=CONCATENATE(cell_1, “delimiter”, cell_2)

cell_1 = string or cell reference for first part

“delimiter” = the separator between the first and second part; common delimiters include spaces, commas, or semicolons, but this part of the formula is optional (remove quotation marks if you do not need to add a delimiter)

cell_2 = the second string or cell reference

You can add as many cells or strings as you would like, each separated by a comma within the parentheses

How to use Google Sheets CONCATENATE

Step 1: Select the cell where you want to add the CONCATENATE function, then type =CONCATENATE followed by the opening parenthesis, as shown below:

Autocomplete option appears while typing in Google Sheets

Step 2: Once the CONCATENATE function is detected by Google Sheets, select the cells where the strings to be combined are included, separating them with a comma. 

You can also type individual strings directly into the function surrounded by quotation marks.

Selecting content to be combined

Step 3: After selecting the cells, press Enter

Concatenated Strings in Google Sheets

The animation below will help make it clearer how simple the process is:

CONCATENATE animation in Google Sheets


Example 1: Concatenating Multiple Cells With Cell Ranges

If you want to combine multiple cells in Google Sheets without delimiters, you can type a cell range into the CONCATENATE function instead of individual cells or individual strings.

For example, we want to combine all five of these columns into one cell. We would type the range A2:D4 into the function to combine all four of the cells into one.

Google Sheets concatenate multiple strings

Example 2: Using Strings in CONCATENATE

You can type the exact strings inside the CONCATENATE function instead of cell references by enclosing the strings in quotation marks.

Google Sheets concatenate strings

Example 3: Adding a Space

You can add a space between the concatenated strings by adding “ ” (a space inside double quotation marks) between the cell references.

Concatenate Google Sheets with space

Example 4: Including Dates

If you need to include dates in CONCATENATE, you must convert them into string first. The easiest way to convert dates into a string in Google Sheets is to type an apostrophe (‘) before typing your date into a cell.

Adding Date to CONCATENATE

Example 5: Concatenating multiple rows/columns

You can also concatenate a range of cells with more than one row or column in Google Sheets. The CONCATENATE formula will process the range, concatenating it from left to right and from the top row to the bottom row and putting all of the data in one cell.

Concatenating multiple rows and columns in Google Sheets

Example 6: Numbering each Entry

Another neat thing that we can do is add a number before each entry. For example, imagine that we want to number each name in our Google Sheets dataset. 

We would type =CONCATENATE(ROW()-1, “ - ”, A2, “ ”, B2).

Numbering Entries

We use “ROW()-1” to give us the number of the entry because we have a header row. If your dataset does not contain a header row, you can use “ROW().


CONCATENATE is a wonderful and versatile function for combining information from multiple cells into one cell in Google Sheets. While the CONCAT formula is similar, it is very limited. We have clearly shown how CONCATENATE can fit many of your needs, and the examples above should help you incorporate this useful tool into your Google Sheets arsenal.

However, if you ever need to undo the effects of this function, check out our article about the SPLIT function in Google Sheets, which allows you to break apart data in one cell into multiple cells.

You might also like our articles on how to transpose in Google Sheets and how to use GOOGLE FINANCE in Sheets.

To optimize your workflow, we recommend checking out our Google Sheets address book template and trying our software for expiration reminders!

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started