TEXTJOIN in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | TEXTJOIN | UNIRCADENAS |
| Syntax | =TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) | =UNIRCADENAS(delimiter; ignore_empty; text1; [text2]; ...) |
| Example | =TEXTJOIN(", ",TRUE,A1:A5) | =UNIRCADENAS(", ";VERDADERO;A1:A5) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What TEXTJOIN does
Joins text with a delimiter and can skip empty cells. Example: Joins A1:A5 separated by commas, ignoring empty cells.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
The second argument decides whether empty cells are skipped (TRUE) or included (FALSE).
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with TEXTJOIN?
The second argument decides whether empty cells are skipped (TRUE) or included (FALSE).