Skip to content
ExcelExcel 2019+

CONCAT function in Excel

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.

=CONCAT(text1, [text2], …)

CONCAT syntax and parameters

Two arguments, one required.

  • text1anyRequired

    Text item to be joined. A string, or array of strings, such as a range of cells.

  • text2anyRepeating

    Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.

CONCAT examples

Formulas you'll actually reuse.

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

    =CONCAT(A2, " ", B2)

    Result"Maria Lopez"

  2. A whole row joined with no separator — CONCAT accepts ranges, CONCATENATE doesn't:

    =CONCAT(A2:D2)

CONCAT in Google Sheets

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