Skip to main content
Version: Streamsheets 3.0

CONCAT

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

Syntax

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

Arguments

NameTypeDescription
Value1StringFirst string to concatenate
Value2, ... (optional)StringAdditional strings to concatenate.

Return

TypeDescription
StringConcatenated string value.

Examples

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