Documentation/How Tos/Calc: LEFT function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:47, 30 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Personal tools