CONCATENATE in Excel & Google Sheets
Joins text, numbers and cells into one string. Useful for full names, codes and labels.
Syntax
=CONCATENATE(text1, [text2…]) Example: Full name from first and last name
=CONCATENATE(A2, " ", B2) =CONCATENAR(A2; " "; B2) Joins the first name in A2, a space and the last name in B2.
CONCATENATE in Spanish
In Spanish Excel and Google Sheets, CONCATENATE is called CONCATENAR. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | CONCATENATE | CONCATENAR |
| Separator | , | ; |
| Example | =CONCATENATE(A2, " ", B2) | =CONCATENAR(A2; " "; B2) |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
CONCATENATE FAQ
What is CONCATENATE in Spanish?
In Spanish, CONCATENATE is CONCATENAR. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =CONCATENAR(A2; " "; B2)
Does CONCATENATE work in Google Sheets?
Yes. CONCATENATE works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called CONCATENAR. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
Is there a shorter way than CONCATENATE?
Yes, the & operator: =A2&" "&B2 gives the same result. To join a whole range with a separator, use TEXTJOIN: =TEXTJOIN(", ", TRUE, A2:A10).