Documentation/Calc Functions/MID

    From The Document Foundation Wiki
    Other languages:


    Function name:

    MID

    Category:

    Text

    Summary:

    Extracts a sub-string from the middle of the supplied text string, with the start position and length of the sub-string specified in characters.

    Syntax:

    MID(Text; Start; Number)

    Returns:

    Returns a text string comprising the specified number of characters from the specified position within the supplied text string.

    Arguments:

    Text is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, that is the string from which characters are to be extracted.

    Start is a positive integer, or a reference to a cell containing a positive integer, that is the position of the first character to be extracted.

    Number is a non-negative integer, or a reference to a cell containing a non-negative integer, that is the number of characters to be extracted.

    • If either Start or Number is non-numeric, then MID reports a #VALUE! error.
    • If either Start or Number is a non-integer value, then MID truncates it to an integer value.
    • If after truncation Start is less than 1, then MID reports an invalid argument error (Err:502).
    • If after truncation Start is greater than the length (in characters) of Text, then MID returns the empty string.
    • If Number is less than 0, then MID reports an invalid argument error (Err:502).
    • If after truncation Number is equal to 0, then MID returns the empty string.
    • If (Start + Number – 1) is greater than the length (in characters) of Text, then MID returns a string comprising all characters from Start to the end of Text.

    Additional details:

    Note that =MID(text; 1; length) is equivalent to =LEFT(text; length)

    Examples:

    Formula Description Returns
    =MID("Input string"; 2; 3) Here the function returns three characters from the supplied string, starting at the second character. npu
    =MID(12,345.6789; 5; 4) Here the function returns four characters from the supplied number, starting at the fifth character, and formats the result as a text string. 5.67
    =MID(D1; D2; D3) where cell D1 contains the string "Input string", cell D2 contains the number 2, and cell D3 contains the number 3. Here the function returns three characters from the supplied string, starting at the second character. npu
    =MID("Input string"; 6; 0) Here the function returns the empty string.

    Related LibreOffice functions:

    LEFT

    MIDB

    RIGHT

    ODF standard:

    Section 6.20.15, part 2

    Related (or similar) Excel functions:

    MID