Skip to content
Google Sheets

CONCAT function in Google Sheets

Returns the concatenation of two values. Equivalent to the `&` operator.

=CONCAT(value1, value2)

CONCAT syntax and parameters

Two arguments, two required.

  • value1anyRequired

    The value to which value2 will be appended.

  • value2anyRequired

    The value to append to value1.

CONCAT examples

Formulas you'll actually reuse.

  1. Two values joined — Sheets' CONCAT takes exactly two arguments, like &:

    =CONCAT(A2, B2)

    Result"NYC10422"

  2. A prefix on a zero-padded number (for more pieces use TEXTJOIN):

    =CONCAT("INV-", TEXT(C2, "0000"))

    Result"INV-0042"

CONCAT in Excel

Same name — your formula ports as-is.

Try CONCAT in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.