How do I use RIGHT in Excel?
Use RIGHT when you want to extract characters from the right side of text. Enter Text, Number of characters in that order, then add optional arguments when needed.
Excel Function
RIGHT
Returns rightmost characters from text.
RIGHT(text, [num_chars])Arguments
text
RequiredValue for text.
num_chars
OptionalEnter a numeric value.
Practice Preview
Use RIGHT to extract the last 3 characters of cell B2 (Name in column B).
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | E003 | Ken Sato | k.sato@example.com | 2450 | 2450 |
| 5 | E004 | Aya Takahashi | a.takahashi@example.com | 3000 | 3000 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=RIGHT(B2, 3)Result
aka
Practice This Function
RIGHT FAQ
Where can I practice RIGHT?
Use the "Start Function Practice" button to jump straight into RIGHT drills.
What arguments does RIGHT use?
The main arguments are Text, Number of characters. Start with the required ones, then add optional arguments if needed.