Better Sheets

How to Use JOIN() in Google Sheets

Description

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

How To Actually Use JOIN() in Sheets

JOIN(delimiter, value_or_array1, [value_or_array2, ...])

Try JOIN yourself

In cells A1:A5, you have a list of first names. Use the JOIN function to concatenate these names into a single string, separated by commas, and place the result in cell B1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

19 Better Sheets Tutorials

Create a 2x2 Priority Matrix

Boost Your Productivity with a Priority Matrix: Learn How to Prioritize Your Tasks and Achieve More! Join us in this different kind of video and discover the best tips and tools to create a two by two grid that helps you determine what's important and urgent. Perfect for daily planners, long-term projects, decision-making, gift-picking, and more! Don't miss out on this collaborative and time-saving approach!

Great use case for the formula combination of JOIN/FILTER.

FILTER() JOIN()

Quadrant to List and List to Quadrant

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.

Intermediate

FILTER() FIND() IF() IFERROR() JOIN()

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Intermediate

ARRAYFORMULA() FILTER() JOIN() SPLIT()

Tic Tac Toe In A Google Sheet

Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

AND() COUNTA() FILTER() IF() IFERROR() +4 more

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.

FILTER() IFNA() JOIN() TRANSPOSE()

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more

Concat Because Concatenate is too hard to Remember!

One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!

CONCAT() CONCATENATE() JOIN()

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.

JOIN() SUBSTITUTE()

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() SPLIT() TRUE()

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.

Intermediate

COUNTIF() FILTER() JOIN() TRANSPOSE()

Mr. Beast Renamed My YouTube Titles

I need help to supercharge my YouTube channel! Are you struggling to find the best strategies to boost your YouTube channel's performance too? Let's see if Mr. Beast can help.

Advanced

INDEX() JOIN() ROW()

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

Prompt Parade

Create an epic writing tool to generate text from AI with a parade of prompts. A list of prompts you create and write that can be used over and over again. Or use this template to create your own workbook to sell a sheet of your own prompts.

Advanced

CONCATENATE() IF() ISBLANK() JOIN()

Duplicate Everything For Each Unique Value

Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.

Intermediate

ARRAYFORMULA() CONCATENATE() JOIN() SPLIT()

Turn Headlines up to 11! - Update to Spintax Tool

Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.

Intermediate

CONCATENATE() IF() JOIN() TRANSPOSE()

Every Possible Permutation - Solved with Spintax

Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax

Intermediate

CONCATENATE() IF() ISBLANK() JOIN() SPLIT()

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.

Advanced

ARRAYFORMULA() IF() INDEX() JOIN() RANDBETWEEN() +3 more

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why. Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.

Beginner

CONCATENATE() JOIN()

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() JOIN() SUMIF() TODAY() YEAR()

Learn more about the JOIN() formula:

Generate a JOIN() formula for your needs

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

Generate a JOIN() formula