TEXTJOIN

Formulas / TEXTJOIN
Combine text values using a delimiter.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
  • delimiter - required argument that separates values that are concatenated together
  • ignore_empty - required argument that controls whether empty values are ignored or added to the result
  • text1 - required argument that is the first value in a join operation
  • text2 - [OPTIONAL] additional text values to join together

Examples

  • =TEXTJOIN(" ",TRUE,A1:A3)

    The TEXTJOIN function can be used to join multiple cells into a single string. This will return the string "Hello, World" as it joins the contents of cells A1, A2, and A3 with a space between each cell.

  • =TEXTJOIN(" ",1,E3,B3:D3)

    The TEXTJOIN function can also accept a range of cells that includes multiple columns.This will join the contents of cell E3, with the contents of cells B3, C3, and D3, separated by a comma and space.

  • =TEXTJOIN("",TRUE,A1,A2)

    The TEXTJOIN function can be used to join multiple cells into a single string with no separator. This will return the string "HelloWorld" as it joins the contents of cells A1 and A2 with no space between them.

  • =TEXTJOIN("-",TRUE,A1,A2)

    The TEXTJOIN function can also be used to join multiple cells into a single string with a specified separator. This will return the string "Hello-World" as it joins the contents of cells A1 and A2 with a hyphen between them.


Summary

The TEXTJOIN function is a useful tool that enables users to combine text from multiple sources with an optional delimiter. It is available on Windows and Mac with Office 2019 or Microsoft 365.

  • The TEXTJOIN function requires three required arguments - delimiter, ignore_empty, and text1
  • The text1 argument is the first text value to join together, and text2, text3, text4, etc. are optional additional text values to join together.
  • The TEXTJOIN function optionally ignores empty cells.

Frequently Asked Questions

What is the TEXTJOIN function?
The TEXTJOIN function is a Microsoft Office tool that allows you to combine text from multiple sources. It includes a delimiter of your choice, which can be an empty text string. You can also join multiple ranges if the delimiter is an empty text string.
Which versions of Office include the TEXTJOIN function?
The TEXTJOIN function is available in Office 2019 or Microsoft 365.
What type of delimiter can I use with the TEXTJOIN function?
You can use any type of delimiter you want. This can be an empty text string, a comma, a period, or any other character.
Can I use the TEXTJOIN function on both Windows and Mac?
Yes, the TEXTJOIN function is available on both Windows and Mac.
Does the TEXTJOIN function work with multiple ranges?
Yes, the TEXTJOIN function can join multiple ranges if the delimiter is an empty text string.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV