Home › TEXTJOIN

TEXTJOIN in every language

TextExcel 2019+Last verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishTEXTJOINTEXTJOIN(delimiter, ignore_empty, text1, [text2])——
GermanTEXTJOINTEXTJOIN(Trennzeichen; Leer_ignorieren; Text1; [Text2])VERBINDENTEXTJOIN
FrenchJOINDRE.TEXTEJOINDRE.TEXTE(séparateur; ignorer_vide; texte1; [texte2])JOINDRE.TEXTETEXTJOIN
SpanishUNIRCADENASUNIRCADENAS(delimitador; ignorar_vacío; Texto1; [Texto2])UNIRCADENASUNIRCADENAS
Portuguese (Brazil)UNIRTEXTOUNIRTEXTO(delimitador; ignorar_vazio; texto1; [texto2])UNIRTEXTOTEXTJOIN
DutchTEKST.COMBINERENTEKST.COMBINEREN(scheidingsteken; lege_negeren; tekst1; [tekst2])TEKST.COMBINERENTEXTJOIN
ItalianTESTO.UNISCITESTO.UNISCI(delimitatore; ignora_vuote; testo1; [testo2])TESTO.UNISCITEXTJOIN

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with TEXTJOIN