LEFT

The LEFT function returns a string value consisting of the specified number of characters from the left end of a given string value.

LEFT(source-string, string-length)

source-string: Any value.

string-length: An optional number value specifying the desired length of the returned string. string-length must be greater than or equal to 1.

Notes

If string-length is greater than or equal to the length of source-string, the string returned is equal to source-string.

Examples
=LEFT(“one two three”, 2) returns “on”. =LEFT(“abc”) returns “a”. =LEFT(60, 1) returns “6”.

Examples

=LEFT(“one two three”, 2) returns “on”.

=LEFT(“abc”) returns “a”.

=LEFT(60, 1) returns “6”.