Documentation/Calc Functions/CONCAT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

CONCAT

Category:

Text

Summary:

Concatenates one or more strings

Syntax:

CONCAT( string1[, string2][, …] )

Returns:

Arguments:

string1[, string2][, …] are strings or references to cells or ranges that contains strings to concatenate.

Additional details:

CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M.

When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate.

Examples:

=CONCAT("Hello ", A1:C3) concatenates the string "Hello" with all strings in range A1:C3.

Related LibreOffice functions:

CONCATENATE
TEXTJOIN

ODF standard:

Equivalent Excel functions: