LEFT

Excerpts a given number of characters from the left side of a string.

Syntax

=LEFT(Text, [NumChars])

Arguments

Name	Description
Text	Text to excerpt string from.
NumChars (optional)	Number, which specifies the amount of characters to return. Default is 1.

Return

Extracted characters from the beginning of specified Text.

Examples

Formula	Result	Comment
=LEFT("SampleText", 3)	"Sam"
=LEFT("Down")	"D"