CONCAT

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

Syntax

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

Arguments

Name	Type	Description
Value1	String	First string to concatenate
Value2, ... (optional)	String	Additional strings to concatenate.

Return

Type	Description
String	Concatenated string value.

Examples

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