What is CONCATENATE called in Spanish?

In Spanish Excel it is CONCATENAR. The formula =CONCATENATE(B2,", ",A2) is written =CONCATENAR(B2;", ";A2) (or with commas in Mexico).

Why does CONCATENATE use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel CONCATENATE function

Joins several texts into one, like the & operator. In Spanish Excel it is called CONCATENAR.

Syntax

English Excel

=CONCATENATE(text1, [text2], …)

Spanish Excel (Mexico)

=CONCATENAR(texto1, [texto2], …)

Spanish Excel (Spain, Latin America)

=CONCATENAR(texto1; [texto2]; …)

Argument	What it is
text1	The first text or cell.
text2optional	More texts, cells or quoted separators.

Example

CONCATENATE(text1, text2…) joins texts, just like the & operator. Spaces and punctuation go in quotes as one more argument. CONCAT is its newer version and also takes ranges.

=CONCATENATE(B2,", ",A2)

Common mistake

It adds no spaces: type them as one more argument, " ". To join a whole range with a delimiter use TEXTJOIN.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice CONCATENATE

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/202

My Excel is inExcel functions in English and Spanish

CONCATENATE and CONCAT

CONCATENATE(text1, text2…) joins texts, just like the & operator. Spaces and punctuation go in quotes as one more argument. CONCAT is its newer version and also takes ranges.

Example=CONCATENATE(B2,", ",A2)CONCATENAR = CONCATENATECONCAT

In C2, write the name as "Last name, First name" using CONCATENATE.

	A	B	C
1	First name	Last name	For the list
2	Carmen	Hernández
3	Jorge	Ortiz
4	Lucía	Ramírez
5	Andrés	Vega
6

Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.

Frequently asked questions

What is CONCATENATE called in Spanish?: In Spanish Excel it is CONCATENAR. The formula =CONCATENATE(B2,", ",A2) is written =CONCATENAR(B2;", ";A2) (or with commas in Mexico).
Why does CONCATENATE use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common CONCATENATE mistake?: It adds no spaces: type them as one more argument, " ". To join a whole range with a delimiter use TEXTJOIN.