LEFT

LEFT the first num_chars characters of the string s

Synopsis

LEFT(s,num_chars)

Arguments

s: the string

num_chars: the number of characters to return (defaults to 1)

Note

If the string s is in a right-to-left script, the returned first characters are from the right of the string.

Microsoft Excel Compatibility

This function is Excel compatible.

OpenDocument Format (ODF) Compatibility

This function is OpenFormula compatible.

See also

MID, RIGHT, LEN, MIDB, RIGHTB, LENB.