LEFT

Returns the specified number of characters from the start of a text string.

Syntax

LEFT(text, num_chars)

Arguments

• text: The text string from which to extract characters.
• num_chars: The number of characters to extract from the left.

Example

LEFT("AnyDB", 3) → Returns "Any"
LEFT(A1, 5) → Returns the first 5 characters of the text in cell A1