Text
Taking the last three characters
Definition
Taking the last three characters means giving RIGHT a word and the length 3.
Syntax
=RIGHT(text, num_chars)
Arguments
| Argument | Meaning |
|---|---|
text |
The cell that holds the word. |
num_chars |
How many characters to take from the end. This lesson uses 3. |
Worked example
A planner stores month names in B2:B4.
| A: Week | B: Month |
|---|---|
| 1 | April |
| 2 | June |
| 3 | July |
Formula: =RIGHT(B2,3)
Result: ril. The last three characters of April are ril.
Practice
Cell A2 holds March. In B2, write a formula that returns the last 3 characters of A2.
- In B2, write a RIGHT formula that takes the last 3 characters of A2.
- B2 should show the last 3 characters of A2.
Step 1 of 2
Enter =RIGHT(A2,3) in B2.
A2 is March, so the last 3 characters are rch.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses RIGHT.
B2 now shows rch.
The next lesson is Counting characters in a code.
Related functions
RIGHT is the function that returns those last three characters.
Common mistake
Taking only two characters, as in =RIGHT(B2,2): that returns il, not the three-character result ril.