RIGHT
Takes characters from the end of text.
How it’s written
RIGHT(text, count)Example
| A | |
|---|---|
| 1 | Code |
| 2 | NOR-4821 |
=RIGHT(A2,4)Result: 4821
Takes the last 4 characters.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
The result is text, even if it looks like a number.
Practice it properly
Pulling text apart gives you real tasks, with your formulas tested on data you haven’t seen.