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 Value

Extracted characters from the beginning of specified Text.

Example

Function Result
=LEFT(“SampleText”, 3) “Sam”
=LEFT(“Down”) “D”