LEFT

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

Syntax

=LEFT(string, count)

Arguments

Argument	Type	Description
string	String	The string to get characters from
count	Number	The 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