Navigation:  Formulas and functions > Functions from A to Z > LEFT (left part of a text string)

Syntax:

LEFT(Text [, n])

Description:

This returns the first n characters of Text.

If n is omitted, only the first character is returned.

Example:

LEFT("peanut", 3) returns pea

LEFT("peanut") returns p

See also:

RIGHT, MID, REPLACE, LEN