= Excel TextJoin =

The '''`TEXTJOIN`''' function concatenates values.

<<TableOfContents>>

----



== Description ==

This function was added in Excel 2019 and Office 365. For legacy systems, use [[Excel/Concatenate|CONCATENATE]].

----



== Usage ==

The arguments for this function are:

{{{
=TEXTJOIN(DELIMITER, IGNORE_EMPTY, VALUE, [VALUE, ...])
}}}

A '''delimiter''' is inserted between every value. If set to `""`, this function is more or less equivalent to [[Excel/Concat|CONCAT]].



=== Order of Ranges ===

Given the following worksheet:

||       ||'''A'''||'''B'''||
||'''1'''||a      ||b      ||
||'''2'''||c      ||d      ||

The formula `=TEXTJOIN(" ",TRUE,A:A,B:B)` would return `a c b d`, while the formula `=TEXTJOIN(" ",TRUE,A1:B2)` would return `a b c d`.



=== Variable Delimiters ===

Given the following worksheet:

||       ||'''A'''||'''B'''||'''C'''||
||'''1'''||a      ||b      ||c      ||
||'''2'''||d      ||e      ||f      ||
||'''3'''||end    ||       ||       ||
||'''4'''||,      ||,      ||;      ||

The formula `=TEXTJOIN(A4:C4,TRUE,A1:C3)` would return `a,b,c;d,e,f;end`.



----
CategoryRicottone