Left
LEFT returns the first character or characters in a text string, based on the number of characters you specify.
Syntax
LEFT(text, [numberOfCharacters])
The function syntax has the following arguments:
- Text (Required) The text string that contains the characters you want to extract.
- numberOfCharacters (Optional) Specifies the number of characters you want LEFT to extract.
- numberOfCharacters must be greater than or equal to zero.
- If numberOfCharacters is greater than the length of text, LEFT returns all of text.
- If numberOfCharacters is omitted, it is assumed to be 1.
Example
Field 1: ="Sale Price"
Field 2: ="Sweden"
| Formula | Description | Result |
|---|---|---|
| =LEFT([Field 1],4) | First four characters in Field 1 | Sale |
| =LEFT([Field 2]) | First character in Field 2 | S |
Updated almost 2 years ago