CONCATENATE in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | CONCATENATE | CONCATENAR |
| Syntax | =CONCATENATE(text1, [text2], ...) | =CONCATENAR(text1; [text2]; ...) |
| Example | =CONCATENATE(A1," ",B1) | =CONCATENAR(A1;" ";B1) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What CONCATENATE does
Joins pieces of text into one. Example: Joins A1 and B1 with a space between them.
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
It does not accept ranges. Newer Excel versions also offer CONCAT and the & operator.
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 CONCATENATE?
It does not accept ranges. Newer Excel versions also offer CONCAT and the & operator.