Skip to content
Google Sheets

CONCATENATE function in Google Sheets

Appends strings to one another.

=CONCATENATE(string1, [string2, ...])

CONCATENATE syntax and parameters

Two arguments, one required.

  • string1stringRequired

    The initial string.

  • string2stringRepeating

    [ OPTIONAL ] - Additional strings to append in sequence.

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 Excel

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 Google Sheets gets this done.