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.
Related Topics