All functions / Text
LEFT
The first characters of a text value.
Syntax
=LEFT(text, [num_chars])
Arguments
text: The text (or a cell containing it).num_chars(optional): How many characters (default 1).
Example
=LEFT("Spreadsheet", 6) → "Spread"
All functions / Text
The first characters of a text value.
=LEFT(text, [num_chars])
text: The text (or a cell containing it).num_chars (optional): How many characters (default 1).=LEFT("Spreadsheet", 6) → "Spread"