Documentation/Calc Functions/CONCATENATE
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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
=CONCATENATE()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 (&) may also be used to concatenate text in a formula, without calling the CONCATENATE function. For example, the formula ="al" & "tog" & "ether" returns the string "altogether".
Examples:
| Formula | Description | Returns |
|---|---|---|
| =CONCATENATE("Life is really simple, "; "but we insist on making it complicated "; "(Confucius).") | Here three individual strings are passed as separate arguments, with the function concatenating them and returning "Life is really simple, but we insist on making it complicated (Confucius).". | Life is really simple, but we insist on making it complicated (Confucius). |
| =CONCATENATE(D1; D2; D3) where cells D1, D2, and D3 contain the strings "When nothing is going right,", " go left", and "!" respectively. | Here three individual strings are passed as cell references, with the function concatenating them and returning "When nothing is going right, go left!". | When nothing is going right, go left! |
| =CONCATENATE("Total: $"; 123.45) | Here a string and a number are passed as arguments, with the function concatenating them and returning "Total: $123.45". | Total: $123.45 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
CONCATENATE