LEFT
Returns the leftmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
What it does
Returns the leftmost characters from a text string.
Syntax
LEFT(text, [num_chars])
Arguments
text(text) — Text to extract from.
Examples
Extract a prefix
Get the first 3 characters of A2.
FORMULA
=LEFT(A2,3)
RESULT
INV
SAMPLE DATA
| A | |
|---|---|
| 1 | Code |
| 2 | INV-1042 |
| 3 | PO-88 |