CONCAT

Turns values of specified cells or cell-ranges into a string.

Syntax

=CONCAT(Value1, [Value2], ...)

Arguments

NameDescription
Value1First string to concatenate
Value2, ...Optional. Additional strings to concatenate.

Return Value

Concatenated string value.

Example

FunctionResult
=CONCAT("My ", "home is my", " castle")My home is my castle.