CONCATENATE and JOIN in Google Sheets - Step-by-Step Guide

Introduction

These functions help you combine text from different cells into one cell. CONCATENATE joins text pieces one after another. JOIN combines text with a separator between each piece. They make it easy to create full names, addresses, or lists from separate parts.

When you want to combine first and last names from two cells into one full name.

When you need to create a sentence by joining words from different cells.

When you want to list items separated by commas from a range of cells.

When you want to merge address parts like street, city, and zip into one cell.

When you want to create a single string from multiple cells with a specific separator.

Steps

Step 1: Click

- the cell where you want the combined text to appear

The cell is selected and ready for input

Step 2: Type

- the formula bar

You start entering the formula

💡 Start with =CONCATENATE( or =JOIN(

Step 3: Enter

- the cells or text you want to join inside the parentheses

The formula includes the cells or text pieces

💡 For CONCATENATE, separate each cell or text with commas, like =CONCATENATE(A1, " ", B1)

Step 4: For JOIN, type

- the separator in quotes, then a comma, then the range of cells

The formula includes the separator and the range, like =JOIN(", ", A1:A3)

Step 5: Press

- Enter key

The combined text appears in the selected cell

Before vs After

Before

Cell A1 has 'John', B1 has 'Doe', and C1 is empty

After

Cell C1 shows 'John Doe' after using =CONCATENATE(A1, " ", B1)

Settings Reference

Separator

📍 Inside the JOIN formula as the first argument

Defines what goes between each joined text piece

Default: ", "

Text pieces or cell references

📍 Inside CONCATENATE or JOIN formulas

Specifies which text or cells to combine

Default: None

Common Mistakes

Using CONCATENATE with a range like A1:A3 directly

CONCATENATE does not accept ranges; it needs individual cells or text pieces separated by commas

Use JOIN with a separator and the range, like =JOIN(", ", A1:A3)

Forgetting to put text separators in quotes

Text separators must be in quotes to be recognized as text, otherwise it causes an error

Always put separators like spaces or commas inside double quotes, e.g., " " or ", "

Summary

CONCATENATE joins text pieces one after another without separators.

JOIN combines text from a range or list with a separator between each piece.

Remember to put text separators in quotes and use JOIN for ranges.