Left

Syntax

Left(Text[, Num_chars])

Text. Source string, from which you get the characters.

Num_chars. The number of characters to be extracted. Optional parameter. The default value is 1.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns the specified number of characters from the start of a text string.

Formula	Result	Description
=Left("zxcv", 2)	zx	The two first characters in the zxcv string.
=Left(B6)	М	The first character in the string from the B6 cell. The B6 cell contains the value "May".