LEFT

Returns the specified number of characters from the beginning (left side) of a text string and outputs the result as text.

The LEFT function returns the first character or characters in a text string, based on the number of characters you specify. When used with a number, the resultant value is stored as text.

Syntax

left(text/number, [num_chars])

Arguments

text/number - The text string that contains the characters you want to extract. Required.

num_chars - Specifies the number of characters you want LEFT to extract. Required.

Example

left([Full Name],4)
//When the field Full Name has the value of Johny Rivers, this will return John

Left function

Excel equivalent

LEFT