Documentation/Calc Functions/CONCAT

Function name:
CONCAT

Category:
Text

Summary:
Concatenates multiple text strings into a single string.

The CONCAT function is an enhanced version of the CONCATENATE function, with CONCAT accepting cell ranges as arguments.

Syntax:
CONCAT(String 1 [; String 2 [; … [; String 255]]])

Returns:
Returns a text string formed by concatenating the string arguments end-to-end.

Arguments:
String 1 is a text string (in quotation marks), a number, a reference to a cell, a reference to a cell range, or an inline array of strings (within curly braces '{' and '}'). String 1 specifies the first string or strings that are to be concatenated.

String 2 through to String 255 are similar to String 1 but specify the subsequent strings that are to be concatenated.


 * The limited utility formula  does not cause an error but returns an empty string.
 * The length of the string to be returned is limited to be less than 256 * (1024)2 characters. If the arguments passed would cause this limit to be exceeded, CONCAT reports a string overflow error (Err:513).

Additional details:
When a cell range is specified, the cells are traversed row by row (from top to bottom).

This function is not a requirement of ODF 1.2 but is compatible with the Microsoft Excel CONCAT function.

Related LibreOffice functions:
CONCATENATE

TEXTJOIN

ODF standard:
None.

Equivalent Excel functions:
CONCAT