TEXTJOIN
Description
Joins a series of text strings into a single text string. You specify a delimiter to
add between the text items. TEXTJOIN is similar to the CONCAT function, but TEXTJOIN
accepts a delimiter, whereas CONCAT can't.
Syntax
TEXTJOIN(
delimiter
,
ignore_empty
,
text
,[
text2
],...)
- delimiter: A delimiter to be inserted between each text string.
- ignore_empty: A logical value that specifies whether to skip or consider empty cells.
- text: A text string or array of text strings.
- text2: An additional text string or array of text strings.
Notes
- If you want to join text containing dates, keep in mind that Worksheets stores dates and times as serial numbers; if you enter a date or a time directly into the TEXTJOIN function, the number displays in the resulting text string instead of the formatted date or time. To display the value as a date, use the TEXT function to convert the date or time into a text string first.