Documentation/Calc Functions/CONCATENATE

Function name:
CONCATENATE

Category:
Text

Summary:
Concatenates multiple text strings into a single string.

The CONCATENATE function is a predecessor of the more capable CONCAT function, with CONCAT accepting cell ranges as arguments.

Syntax:
CONCATENATE(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, or a reference to a cell, that specifies the first string that is to be concatenated.

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


 * If any of String 1 to String 255 specify a cell range, then CONCATENATE reports a #VALUE! error.
 * 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, CONCATENATE reports a string overflow error (Err:513).

Additional details:
The ampersand operator (&amp;) may also be used to concatenate text in a formula, without calling the CONCATENATE function. For example, the formula  returns the string "altogether".

Related LibreOffice functions:
CONCAT

TEXTJOIN

ODF standard:
Section 6.20.6, part 2

Equivalent Excel functions:
CONCATENATE