LEFT

The LEFT function returns the specified number of characters from the beginning of a text string. When used with a number, the function returns the result as text.

Syntax

LEFT(text, num_chars)

Arguments

• text: The text string that contains the characters to extract.
• num_chars: The number of characters to extract from the beginning of the text.

Return value

Returns the specified number of characters from the left side of the text string.

Example

LEFT([Full Name], 4)

If Full Name contains Johny Rivers, the function returns John.

Excel equivalent

LEFT