Returns the leftmost characters of a string.
Sample Usage
LEFT("spreadsheet",6)
LEFT(C5)
Syntax
LEFT(text, [number])
- text - The string whose leftmost characters are returned.
- number - [OPTIONAL]The number of characters to return.
Examples
LEFT("spreadsheet",6) returns six leftmost characters of the string - "spread".
LEFT(C5) returns the leftmost character of the string in C5.
Notes
- If number is omitted, it is assumed to be 1.
- number must be greater than or equal to zero.
- If number is greater than the length of text, LEFT returns all of text .