In this tutorial, you will learn how to use the TEXTJOIN function in Google Sheets.
How to Use TEXTJOIN Function in Google Sheets
Quick Navigation
The TEXTJOIN function in Google Sheets can be a helpful tool when you need to combine data from multiple cells into a single string.
For example, you may have a list of first names in one column and a list of last names in another column. You could use the TEXTJOIN function to combine these two columns into a single column that contains the full name of each person.
The TEXTJOIN function can join multiple strings together using any arbitrary separator. You can even use the function to convert a range of cells into a string of comma-separated values.
In this guide, we will show you how to use the TEXTJOIN function in Google Sheets.
How to Combine Text Strings Using TEXTJOIN in Google Sheets
Here’s how to combine text string using TEXTJOIN in Google Sheets.
Step 1
First, select an empty cell and type the TEXTJOIN function.
Step 2
We’ll use the “ “ or whitespace character as our delimiter.
Step 3
Next, we’ll need to indicate what the TEXTJOIN function should do with empty cells. If we set the value to TRUE, the TEXTJOIN function will simply skip over the empty cell.
Step 4
Next, write down the range you want to combine into a single string.
In the example above, we were able to combine our first and last names into a single value.
Step 5
We can use any character or string as our delimiter.
For example, instead of spaces we can use underscores.
If we set our second value to TRUE, our TEXTJOIN function will automatically skip over the blank values.
Summary
This guide should be everything you need to use the TEXTJOIN function in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.