These docs are for v1.0. Click to read the latest docs for v1.2.

LEFT

Returns the specified number of characters from the start of the string.

Syntax

=LEFT(string, count)

Arguments

ArgumentTypeDescription
stringStringThe string to get characters from
countNumberThe number of characters to get

Examples

=LEFT("ABCDEF", 2)"AB"
Gets the first 2 characters from the string "ABCDEF"

=LEFT("GHIJKL", 1)"G"
Gets the first character from the string "GHIJKL"

=LEFT("MNOPQR", 0")#ERROR!
Gets the first 0 characters from the string "MNOPQR" (returns an error because the number of characters must be greater than or equal to 1