Skip to content
Excel

CONCATENATE function in Excel

Joins several text items into one text item

=CONCATENATE(text1, [Text2, ...])

CONCATENATE syntax and parameters

Two arguments, one required.

  • text1anyRequired

    The first item to join. The item can be a text value, number, or cell reference.

  • Text2anyRepeating

    Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.

CONCATENATE examples

Formulas you'll actually reuse.

  1. A full name from first- and last-name columns:

    =CONCATENATE(A2, " ", B2)

    Result"Maria Lopez"

  2. A zero-padded invoice number with the year:

    =CONCATENATE("INV-", TEXT(C2, "0000"), "-", TEXT(D2, "yyyy"))

    Result"INV-0042-2026"

CONCATENATE in Google Sheets

Same name — your formula ports as-is.

Try CONCATENATE in the playground

Edit the example — nothing to install.

Preloaded with the CONCATENATE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.