LEFT, RIGHT and MID
Extract a useful part from a text code
0 of 3 done · Lesson 15 of 18
Understand
An operations report packs country, office and case number into one code. LEFT takes characters from the beginning, RIGHT takes them from the end, and MID takes a section from the middle.
=LEFT(text to cut, characters from the left, optional)
=RIGHT(text to cut, characters from the right, optional)
=MID(text to cut, where to start, characters to take)
A worked example
=RIGHT(A2, 4)
text to cutcharacters from the left
A2 is NZ-AKL-1042, so this returns 1042
The sheet you are working with
| Row number | A | B | C |
|---|---|---|---|
| 1 | Case code | Owner | Team |
| 2 | NZ-AKL-1042 | Amelia | Sales |
| 3 | AU-SYD-2075 | Hemi | Support |
| 4 | NZ-WLG-3184 | Priya | Finance |
| 5 | NZ-CHC-4221 | Leo | Operations |
| 6 | AU-MEL-5360 | Sofia | Sales |
| 7 | NZ-DUD-6408 | Noah | Support |