CONCAT

Concatenates a text-expressions into a single text value. Numbers are converted to text as needed.

Syntax

CONCAT(text-expression,{text-expression},...)

Arguments

text-expression

Text or cell reference to concatenate

Example

CONCAT("Number: ",100) returns Number: 100