LEFT

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

Syntax

=LEFT(Text[, NumChars])

Arguments

NameDescription
TextText to excerpt string from.
NumCharsOptional. Number, which specifies the amount of characters to return. Default is 1.

Return Value

Extracted characters from the beginning of specified Text.

Example

FunctionResult
=LEFT("SampleText", 3)"Sam"
=LEFT("Down")"D"