CONCATENATE

Try it

When to use it

When should I use CONCATENATE instead of the & operator?

They produce the same result for joining text. Use & for short, inline joins; CONCATENATE reads more clearly when you are stitching together many separate pieces.

How is CONCATENATE different from TEXTJOIN?

CONCATENATE glues its arguments together with no separator and ignores empty handling. TEXTJOIN lets you set a delimiter and skip blanks, which is better for building lists.

Use cases

Compose a SKU from parts

Join a label with a number

Used in

operations · retail

Syntax

CONCATENATE(value1,...)