LEFT
Takes characters from the start of text.
How it’s written
LEFT(text, count)Example
| A | |
|---|---|
| 1 | Code |
| 2 | NOR-4821 |
=LEFT(A2,3)Result: NOR
Takes the first 3 characters.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
For text of varying length, use FIND to work out the count.
Practice it properly
Pulling text apart gives you real tasks, with your formulas tested on data you haven’t seen.