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”