Statistical - TEXTJOIN Function

Description

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

This function was added in Excel 2016.

Syntax

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

Arguments

Argument	Description	Required/ Optional
delimiter	A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.	Required
ignore_empty	If TRUE, ignores empty cells.	Required
text1	Text item to be joined. A text string, or array of strings, such as a range of cells.	Required
Text2, ...	Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.	Optional

Notes

If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! Error.

Applicability

Excel 2016

Example

advanced_excel_statistical_functions.htm