CONCATENATE

Combine several pieces of text into one. Superseded by CONCAT, TEXTJOIN and the ampersand.

Syntax

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

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

Examples

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

Formula	Result	Notes
`=CONCATENATE("a","b")`	`ab`
`="a"&"b"`	`ab`	Identical result, less typing.

Supported so old files open, not because you should use it

CONCATENATE is the original joining function, kept for compatibility. Microsoft replaced it with CONCAT and TEXTJOIN, and it has no advantage over either — or over the ampersand:

=CONCATENATE(A1, " ", B1)
=A1 & " " & B1

The second is the same formula with less ceremony. If you are writing something new, use TEXTJOIN when there is a separator and & when there is not.

It is here so that a workbook written in 2009 opens and computes correctly, which is the whole reason a spreadsheet keeps functions nobody would choose today.

Excel compatibility

Matches Excel.