CONCAT

Combine several pieces of text into one.

Syntax

CONCAT(text1, [text2], ...)

Argument	Required	Description
`text1`	Required	The first piece of text.
`text2`	Optional	Further pieces, joined in order with nothing between them.

Examples

Every example below was executed against VisiGrid engine 0.31.0 — not transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.

Formula	Result	Notes
`=CONCAT("a","b","c")`	`abc`
`="a"&"b"`	`ab`	The ampersand operator does the same thing and is shorter.

You probably want & or TEXTJOIN

CONCAT sits awkwardly between two better options.

For a couple of values, the ampersand is shorter and reads better:

="Hello " & A1

For a list with a separator between the parts, TEXTJOIN is the right tool — it takes the delimiter once instead of repeating it between every argument, and it can skip empty values:

=TEXTJOIN(", ", TRUE, A1, B1, C1)

CONCAT is worth knowing because it appears in inherited spreadsheets, and because it accepts ranges where & does not. Reach for it when neither of the other two fits.

Excel compatibility

Matches Excel.