LEFT
Excerpts a given number of characters from the left side of a string.
Syntax
=LEFT(Text, [NumChars])
Arguments
| Name | Type | Description |
|---|---|---|
| Text | String | Text to excerpt string from. |
| NumChars (optional) | Number | Number, which specifies the amount of characters to return. Default value: 1 |
Return
| Type | Description |
|---|---|
| String | Extracted characters from the beginning of specified Text. |
Examples
| Formula | Result | Comment |
|---|---|---|
| "Sam" | |
| "D" |