How to Use TEXTJOIN() in Google Sheets

Description

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts..

How To Actually Use TEXTJOIN() in Sheets

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Try TEXTJOIN yourself

Use the TEXTJOIN formula to combine the names in the range A1:A5 into a single string, separated by commas. The result should be placed in cell B1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for TEXTJOIN(). Click through to watch.

Browse more tutorials

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease...

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...

Beginner

CONCATENATE() JOIN()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Unlock these tutorials

Learn more about the TEXTJOIN() formula:

Generate a TEXTJOIN() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses TEXTJOIN(). 2 free AI generations, no signup. Members get unlimited use.

Generate a TEXTJOIN() formula

How to Use TEXTJOIN() in Google Sheets

Try TEXTJOIN yourself

More related tutorials

Create Hundreds of Tweets in a Google Sheet

How to Merge Cells in Google Sheets

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.