Documentation/How Tos/Calc: LEFT function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 16:05, 13 September 2008 by Drking (Talk | contribs)

Jump to: navigation, search


LEFT

Returns text from the left side of a text string.

Syntax:

LEFT(text; number)

returns number characters from the left side of the text text.
number defaults to 1 if omitted.

Example:

LEFT("output"; 3)

returns out.

See also:

RIGHT, MID, LEN

Text functions

Functions listed alphabetically, Functions listed by category

Personal tools