Documentation/Calc Functions/MID

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MID

Category:

Text

Summary:

Returns a text string of a text. The parameters specify the starting position and the number of characters.

Syntax:

MID("Text"; Start; Number)

Returns:

Arguments:

Text is the text containing the characters to extract.

Start is the position of the first character in the text to extract.

Number specifies the number of characters in the part of the text.

Additional details:

Examples:

=MID("office";2;2) returns ff.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: