Excel function

CONCATENATE in Excel: combine text and cells

CONCATENATE joins text values together. It is useful for building names, labels, IDs, messages, and simple codes from separate spreadsheet cells.

What CONCATENATE does

CONCATENATE combines two or more text items into one result. The syntax is `=CONCATENATE(text1, [text2], ...)`. Each argument can be typed text, a cell reference, or another formula result.

For example, `=CONCATENATE(A2," ",B2)` combines the first name in A2, a space, and the last name in B2. If A2 is Maya and B2 is Chen, the result is Maya Chen.

CONCATENATE is still available in Excel, but newer versions also include CONCAT and TEXTJOIN. The ampersand operator `&` is another common alternative: `=A2&" "&B2`.

Arguments explained

`text1` is the first value to join. `text2` and later arguments are added in order. Excel does not automatically add spaces or punctuation. If you want a space, comma, dash, slash, or label, you must include it as text in quotation marks.

Cell references are inserted as their displayed values. Typed text must be in quotation marks, such as `" - "` or `"Order "`. Numbers can be combined too, but if you need a specific date, currency, or percentage format inside text, use TEXT to control the format.

CONCATENATE is simple and explicit. TEXTJOIN is better when you need to join many cells with the same delimiter or ignore blanks. CONCAT can combine ranges in newer Excel versions.

When the combined text will be used as a lookup key, consistency matters. A missing space, extra dash, or different date format can make two values look similar to a person but different to Excel.

Practical examples

A beginner example is building a full name. If A2 contains first name and B2 contains last name, `=CONCATENATE(A2," ",B2)` returns one full-name string.

A business example is creating an order label. If B2 contains a region code, C2 contains an order number, and D2 contains a status, `=CONCATENATE(B2,"-",C2," (",D2,")")` might return `NE-1042 (Open)`.

A school example is building a class label from grade and section. `=CONCATENATE("Grade ",A2,"-",B2)` turns separate values into a readable label like Grade 10-B.

When to use it

Use CONCATENATE when you need to build simple labels, IDs, names, or messages from a few cells. It is easy to read when the formula has only a handful of pieces.

Do not use CONCATENATE for complex text cleanup by itself. It joins text but does not remove extra spaces, change casing, or parse values. Use TRIM, PROPER, LEFT, MID, TEXT, CONCAT, or TEXTJOIN when those tools fit better.

Practical examples

Combine first and last name

=CONCATENATE(A2," ",B2)

Joins A2, a space, and B2 into one full-name value.

Build an order label

=CONCATENATE(B2,"-",C2," (",D2,")")

Combines region, order number, punctuation, and status into one label.

Recommended Excel functions

CONCATENATECONCATTEXTJOINTEXTLEFTMID

Common mistakes

  • 01Forgetting to include spaces or punctuation as separate text arguments.
  • 02Expecting CONCATENATE to clean messy text automatically.
  • 03Combining dates or percentages without TEXT when a specific format is needed.
  • 04Using a very long CONCATENATE formula when TEXTJOIN would be easier.

Practice

Practice this skill with interactive exercises on Calcu.

Use Calcu to practice CONCATENATE in realistic spreadsheet exercises with instant feedback.

Open Calcu

FAQ

What does CONCATENATE do in Excel?

CONCATENATE joins text, cell values, and typed separators into one text result.

How do I add a space in CONCATENATE?

Add a quoted space as its own argument, such as =CONCATENATE(A2," ",B2).

Is CONCATENATE still available?

Yes. CONCATENATE is still available, although newer Excel versions also include CONCAT and TEXTJOIN.