Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

TEXTJOIN in Google Sheets (easy guide)

While spreadsheets are more of a home for numbers than for text, there are many occasions when you need to work with the string data type. The names and characteristics of products, the names and addresses of customers, and qualitative data from surveys are just a few of the many text items you regularly find in your Google Sheets. These texts are often split into multiple cells – first name and last name, different address lines – and you need to join them. Fortunately, Google Sheets provides a few solutions, including TEXTJOIN.

In this guide, you will learn about the TEXTJOIN function and its syntax in Google Sheets. You have step-by-step instructions on how to use the function in different scenarios using different options. You will also learn about three other methods you can use to join text items: the ampersand symbol (&), CONCATENATE, and JOIN. Finally, you will learn the differences between CONCATENATE and TEXTJOIN.

What is TEXTJOIN in Google Sheets?

Google Sheets’ TEXTJOIN function combines text from multiple strings or arrays of strings using the delimiter you specify. The delimiter can be a string or a reference to a cell containing one. The function also allows you to determine whether or not empty cells should be ignored.

Google Sheets TEXTJOIN syntax

The syntax of the TEXTJOIN function in Google Sheets is as follows:

=TEXTJOIN(delimiter, ignore_empty, text1, [textN])

  • delimiter: the delimiter you want between the text items. It can be a string or a reference to a cell containing a string.
  • ignore_empty: a Boolean parameter. If TRUE, empty cells will be ignored.
  • text1: any text item, which could be a string or an array of strings in a range of cells.
  • textN*: optional. Additional text items are also in the form of strings or arrays of strings.

How do I use TEXTJOIN in Google Sheets?

To use the TEXTJOIN function in Google Sheets, you must specify the delimiter first between quotation marks. Second, choose whether to ignore empty cells. Third, select the cells or the arrays of cells containing your text items.

Below, you have step-by-step instructions on how to use the TEXTJOIN function in different situations. First, you will use the function to join first and last names using a space as the delimiter. Second, you will learn how to do the same when you also have middle names, but only for some people. Third, you will learn how to join the different parts of an address using the line break as a delimiter.

Example 1. How to join text with spaces?

Follow the steps below to join text items using a space as the delimiter.

1. Open Google Sheets to the spreadsheet with your data.

Google Sheets TEXTJOIN — first_name and last_name columns selected in a spreadsheet

2. In the column where you want the full names, type the TEXTJOIN function.

Google Sheets TEXTJOIN — TEXTJOIN typed in cell C2 under full_name with the syntax helper open

3. For the first parameter, type a quotation mark, then add a space before the second quotation mark. The second parameter can be FALSE since there are no empty cells.

Google Sheets TEXTJOIN — a space delimiter and FALSE typed as the first two arguments in C2

4. Select the first row of cells with text items and close the parenthesis.

Google Sheets TEXTJOIN — cells A2:B2 added to the formula with a Thaxter Broschke preview

5. Press ‘Enter’ to see the results. Accept the suggested autofill or grab the fill handle and drag it down to the last row.

Google Sheets TEXTJOIN — full names joined by spaces in column C with the Suggested autofill box

Example 2. How to ignore empty cells?

In this example, I have first and last names for every person on my list, but I also have middle names for a few of them. Follow the steps below to join them using spaces while ignoring empty cells.

1. In the cell where you want the full names, type the TEXTJOIN function and use a space between quotation marks as the delimiter.

TEXTJOIN ignore empty cells — space delimiter typed in D2 next to a middle_name column with gaps

2. For the second parameter, type TRUE to ignore empty cells.

TEXTJOIN ignore empty cells — TRUE typed as the ignore_empty argument in cell D2

3. Select the first row of your data, including all three columns.

TEXTJOIN ignore empty cells — first, middle, and last name cells A2:C2 added to the formula

4. Close the parenthesis and press ‘Enter’ to see the results. Accept the suggested autofill or grab the fill handle to copy the formula down to the last row.

TEXTJOIN ignore empty cells — full names joined with no extra spaces and the Suggested autofill box

Example 3. How to join text with line breaks?

Imagine you have a table with customer addresses split over four cells: street address, city, state, and country. However, instead of joining them with spaces, I want to use line breaks so that each item has a new line in the cell.

1. In the cell where you want the full address, type the TEXTJOIN function.

TEXTJOIN with line breaks — empty cell G2 selected under Full Address next to the address table

2. Type CHAR(10) as the first parameter to add a new line for every text item.

TEXTJOIN with line breaks — CHAR(10) typed as the delimiter in cell G2

3. You can use TRUE for the second parameter in case there are any empty cells in your data.

TEXTJOIN with line breaks — TRUE added after CHAR(10) as the ignore_empty argument

4. Select the first row of text items in all four columns.

TEXTJOIN with line breaks — address cells A2:E2 added to the formula with a preview of the result

5. Close the parenthesis and press ‘Enter’ to see the results. Use the fill handle to copy the formula down to the last row.

TEXTJOIN with line breaks — each address shown on five lines in the Full Address column

What can I use instead of TEXTJOIN?

When you need to join texts in Google Sheets, TEXTJOIN is not your only option. First, you can use the ampersand symbol (&) within your formulas to append items. Second, you can use the CONCATENATE function to do the same. Third, you can use JOIN to also specify a delimiter.

Let’s see how to concatenate text items using all three methods to get the same result.

To join strings using the ampersand (&), type the equal sign followed by the first item, then the ampersand, then the delimiter between quotation marks, followed by another ampersand, then the second item, and so on. In other words, this method involves a fair amount of typing.

Join text in Google Sheets with the ampersand — formula joining A2 to D2 with commas in cell A5

With CONCATENATE, you list every item and every delimiter as its own argument, with commas between them.

Join text in Google Sheets with CONCATENATE — formula in A8 with a comma between each cell

With JOIN, you type the delimiter once as the first argument and then select the range of cells you want to join.

Join text in Google Sheets with JOIN — comma delimiter and range A2:D2 in A11 give the same address

What is the difference between the CONCATENATE function and the TEXTJOIN function?

The CONCATENATE function has no built-in parameter to specify the delimiter. If you want to use one, you have to add it manually between each item you want to concatenate. TEXTJOIN, however, allows you to specify the delimiter as the first parameter. Additionally, you can choose whether to ignore empty cells.

To learn more about CONCATENATE, check out our guide on how to use CONCATENATE in Google Sheets.

Conclusion

TEXTJOIN is a very useful function to know. The function allows you to join multiple text items or arrays of items, specify the delimiter you want to use, and decide whether to ignore empty cells. While there are other options when it comes to appending strings in Google Sheets, TEXTJOIN provides more flexibility and control over the process.

You now know about the TEXTJOIN function and its syntax in Google Sheets. You have step-by-step instructions on how to use the function to achieve different results: join text by using spaces as delimiters, ignoring empty cells, and using line breaks as delimiters. You also know how to use alternatives to TEXTJOIN, like the ampersand symbol (&), CONCATENATE, and JOIN. Finally, you know the main differences between CONCATENATE and TEXTJOIN.

Google Sheets also has a CONCAT function, which joins only two values. See how it works in our guide to the CONCAT formula in Google Sheets.

You may also like…

google sheets features and formulas

How to find nominal interest rate using Google Sheets

Sarah is a young professional making significant financial decisions. From credit cards to mortgages, student loans, and investment...
google sheets features and formulas

Pull Google Calendar data into Google Sheets using Apps Script

This post was originally published in our community forum. Objective : This guide demonstrates how to use Google Apps Script to pull data...
google sheets features and formulas

Using the PROPER function to capitalize the first letter of each word in Google Sheets

Note: This post was originally published in our community forum. Ever found yourself needing to clean up a list of names, titles, or any...