TEXTJOIN
Concatenates one or more strings, and uses delimiters between them.
TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )
delimitador es una cadena de texto y puede ser un intervalo.
skip_empty is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored.
string1[, string2][, …] are strings or references to cells or ranges that contains text to join.
Ranges are traversed row by row (from top to bottom).
Si delimitador es un intervalo, este no necesariamente debe ser del mismo tamaño que el número de cadenas que se unirán.
Si existen más delimitadores que cadenas por unir, no se emplearán todos los delimitadores.
If there are less delimiters than strings to be joined, the delimiters will be used again from the start.
=TEXTJOIN(" ",TRUE, "Here", "comes", "the", "sun") returns "Here comes the sun" with space character as delimiter and empty strings are ignored.
if A1:B2 contains "Here", "comes", "the", "sun" respectively, =TEXTJOIN("-",TRUE,A1:B2) returns "Here-comes-the-sun" with dash character as delimiter and empty strings are ignored.