LEFT

Get a substring from the left of a specified string.

Parameter List

Syntax
LEFT(string
[chars]
)
string

The string from which you want the left-side characters. For example: "Built with a spreadsheet".

[optional] chars

The number of characters to return from string. Must be greater or equal to 0. Zero returns an empty string. For example: 5. By default set to 1.

Examples

LEFT(A1, 5) returns Super, as it's the first five characters (counting from the left) of Superman.Example 1