TEXTJOIN function in Excel

Syntax

=TEXTJOIN(delimiter, ignore_empty, text1, …)

Example

=TEXTJOIN(", ",TRUE,A2:C2) joins the row with commas and drops blanks.

From the lesson TEXTJOIN Function.

Common mistakes

• Setting ignore_empty to FALSE and ending up with ", ," in the result.
• Forgetting the space inside the delimiter.

Related text functions

• LENReturns the number of characters.
• LEFTReturns characters from the start of the text.
• RIGHTReturns characters from the end of the text.
• MIDReturns characters from the middle of the text.
• FINDCase-sensitive position of text within text.
• SEARCHCase-insensitive position of text; supports wildcards.
• CONCATJoins text from cells and ranges.
• CONCATENATEJoins text items (legacy).