CONCAT

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

Syntax

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

Arguments

Name	Description
Value1	First string to concatenate
Value2, ...	Optional. Additional strings to concatenate.

Return Value

Concatenated string value.

Example

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