TEXTJOIN

• How to use TEXTJOIN formula?
• Examples of using TEXTJOIN formula
• TEXTJOIN formula not working?
• Similar formulas to TEXTJOIN

Usage

Use the TEXTJOIN formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

1. delimiter (required):
   The character or characters to insert between each text string. This can be a single letter, number, symbol, or a longer string of characters. Use quotes to enclose the delimiter.
2. ignore_empty (required):
   A boolean value that determines whether or not to include empty cells in the output. If set to TRUE, empty cells will be skipped. If set to FALSE, empty cells will be included with the delimiter between them.
3. text1 (required):
   The first text string to include in the output. This can be a cell reference, a quoted string, or a formula that returns a text string.
4. text2 (optional):
   Optional. Additional text strings to include in the output. You can include up to 30 text strings in a single formula.

Examples

Combine a list of values

If you have a list of values in separate cells and you want to combine them into a single cell with a delimiter between each value, you can use TEXTJOIN. For example, to combine a list of names in cells A1:A5 with a comma between each name, you could use the formula: =TEXTJOIN(", ", TRUE, A1:A5).

Create a sentence

You can use TEXTJOIN to create a sentence from multiple text strings. For example, to create the sentence "The quick brown fox jumps over the lazy dog." from separate cells, you could use the formula: =TEXTJOIN(" ", TRUE, "The", "quick", "brown", "fox", "jumps", "over", "the", "lazy", "dog.").

Format data for export

If you need to export data from Google Sheets into another program or file format, you may need to format the data in a specific way. TEXTJOIN can be useful for creating custom output formats. For example, to create a comma-separated list of email addresses from a list of names and email addresses, you could use the formula: =TEXTJOIN(", ", TRUE, B2:B5), assuming the email addresses are in column B.

Common Mistakes

Missing delimiter

One of the most common mistakes when using the TEXTJOIN function is forgetting to include a delimiter. Make sure to include a delimiter as the first parameter.

Incorrect data type

Make sure that the values you are trying to join are text values. If you are trying to join numbers or dates, use the TEXT function to convert them to text first.

Too many arguments

The TEXTJOIN function can only accept up to 30 arguments for the text parameter. If you need to join more than 30 values, consider using a different formula or combining the values with a different method.

Related Formulas

The following functions are similar to TEXTJOIN or are often used with it in a formula:

• CONCAT

  The CONCAT formula in Google Sheets is used to combine two or more strings or cell values into a single string. It is most commonly used to join values from different cells or to create a custom message or label. The operator CONCAT can also be used in combination with other formulas to manipulate the joined values.

• JOIN

  The JOIN formula concatenates the elements of one or more arrays using a specified delimiter string. It is commonly used to combine text strings or to create comma-separated lists of values.

• LEFT

  The LEFT formula is used to extract a specific number of characters from the beginning of a text string. It is most commonly used to extract the first name or last name from a full name or to extract a date from a text string.

• RIGHT

  The RIGHT formula in Google Sheets returns the rightmost characters from a string, based on the number of characters specified. It is commonly used to extract a certain number of characters from the end of a string. The formula takes two arguments: the string from which to extract the characters, and the number of characters to extract.

Learn More

You can learn more about the TEXTJOIN Google Sheets function on Google Support.