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.