CONCATENATE Generator
Join text from several cells, with your own spaces or punctuation between them.
CONCATENATE
Join text from several cells, with your own spaces or punctuation between them.
The first cell or value to join. Literal text needs quotes, for example "Mr. ".
CONCATENATE never adds spaces on its own, so put the separator here in quotes, for example " " or ", ".
The next cell or value to join. Add more arguments inside the brackets if you need them.
=CONCATENATE(A2, " ", B2)Worked Example
A2 contains Ada and B2 contains Lovelace, and you want a full name in column C.
=CONCATENATE(A2, " ", B2)Returns: Returns the text Ada Lovelace, with the single space supplied by the quoted middle argument.
Checks Before You Paste
- •In Excel, CONCATENATE takes arguments one at a time, not ranges: =CONCATENATE(A2:A10) never joins the column. It returns only the value on the formula's own row, or spills one unchanged value per row. Use CONCAT(A2:A10) or TEXTJOIN(", ", TRUE, A2:A10) for a whole range.
- •CONCATENATE inserts nothing between items, so every space, comma, or dash has to be its own quoted argument, for example =CONCATENATE(A2, ", ", B2).
- •Numbers and dates arrive stripped of their formatting: a date joins as its serial number, so 5 August 2026 becomes 46239. Wrap it in TEXT first, for example =CONCATENATE(A2, " - ", TEXT(B2, "mm/dd/yyyy")).