Documentation/Calc Functions/LEFT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

LEFT

Category:

Text

Summary:

Returns the first character or characters of a text.

Syntax:

LEFT("Text"; Number)

Returns:

Arguments:

Text is the text where the initial partial words are to be determined.

Number (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned.

Additional details:

Examples:

=LEFT("output";3) returns “out”.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: