TEXTJOIN

New Excel function in Excel 2016

The TEXTJOIN function works in a similar way as the existing CONCATENATE function. The key differences are that you can control the delimiter that is used when joining text, choose if empty cells are ignored and reference ranges instead of individual cells.

Syntax

TEXTJOIN(delimiter,ignore_empty,text1, [text2],…)

The delimiter is a text string that will be used to join the text values.

If Ignore_empty is set to TRUE, empty cells are ignored.

The text can be text, a cell reference or a range.

All [text] vales after the first value are optional.

Best to use

• To make dynamic report headings or text.
• In constructing SQL statements.

Limitations

The function can reference 254 pieces of text, cells or ranges.

It will return a maximum of 32767 character before showing #VALUE!

Examples