The LEFT function
Returns the first characters of a text. Without num_chars it returns one character.
Syntax
LEFT(text, [num_chars])- text
- The text to take characters from.
- num_chars (optional)
- How many characters to return. Default 1.
Examples
C1
=LEFT(1A2,22)| A | B | C | |
|---|---|---|---|
| 1 | Code | DK | |
| 2 | DK-2100 |
In plain words: Take 2the first 2 characters of 1the code in A2.
C1=LEFT(A2)
| A | B | C | |
|---|---|---|---|
| 1 | Code | D | |
| 2 | DK-2100 |