Excel Function : TEXTJOIN
Category
Text
Description
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.
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c
Syntax and Description of the TEXTJOIN Excel Function
syntax TEXTJOIN function syntax TEXTJOIN function syntax syntax TEXTJOIN function TextJoin function syntax excel function syntax TEXTJOIN function syntax TEXTJOIN function syntax TEXTJOIN function syntax excel function syntax TEXTJOIN function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function syntax excel function
About TEXTJOIN Excel Function
The TEXTJOIN function returns a combined text string from a range of cells. =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) delimiter: The character or string that will be used to separate the text strings. ignore_empty: TRUE or FALSE. If TRUE, empty cells are ignored. If FALSE, empty cells are included. text1, [text2], …: The cell or range of cells to be combined.
