LEFT
Returns the specified number of characters from the start of the string.
Syntax
=LEFT(string, count)
Arguments
| Argument | Type | Description |
|---|---|---|
| string | String | The string to get characters from |
| count | Number | The number of characters to get |
Examples
=LEFT("ABCDEF", 2)→"AB"
Gets the first 2 characters from the string "ABCDEF"
=LEFT("GHIJKL", 1)→"G"
Gets the first character from the string "GHIJKL"
=LEFT("MNOPQR", 0")→#ERROR!
Gets the first 0 characters from the string "MNOPQR" (returns an error because the number of characters must be greater than or equal to 1
Updated 9 months ago