LEFT function

The LEFT function selects a specified number of characters starting from the leftmost character of a character expression.

Syntax

LEFT(expression,number)

Example

LEFT("ABCDEF",3)

The cell displays ABC.