Documentation/Calc Functions/CONCATENATE

    From The Document Foundation Wiki
    Other languages:


    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:

    CONCAT

    TEXTJOIN

    ODF standard:

    Section 6.20.6, part 2

    Related (or similar) Excel functions:

    CONCATENATE