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

Concatenated string value.

Examples

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