LEFT
Excerpts a given number of characters from the left side of a string.
Syntax
=LEFT(Text[, NumChars])
Arguments
Name | Description |
---|---|
Text | Text to excerpt string from. |
NumChars | Optional. Number, which specifies the amount of characters to return. Default is 1. |
Return Value
Extracted characters from the beginning of specified Text.
Example
Function | Result |
---|---|
=LEFT("SampleText", 3) | "Sam" |
=LEFT("Down") | "D" |