Text
Taking a suffix from a word
Definition
Taking a suffix from a word means giving RIGHT the word and how many ending characters to keep.
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. |
Worked example
A shipping list stores country names in B2:B4. The last two letters are used as a short suffix.
| A: Box | B: Country |
|---|---|
| 1 | Spain |
| 2 | Poland |
| 3 | Japan |
Formula: =RIGHT(B2,2)
Result: in. The last two characters of Spain are in.
Practice
Cell A2 holds Excel. In B2, write a formula that returns the last 2 characters of A2.
- In B2, write a RIGHT formula that takes the last 2 characters of A2.
- B2 should show the last 2 characters of A2.
Step 1 of 2
Enter =RIGHT(A2,2) in B2.
A2 is Excel, so the last 2 characters are el.
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 el.
The next lesson is Counting letters in a name.
Related functions
RIGHT is the function that pulls that suffix from the end of the word.
Common mistake
Taking the start instead, as in =LEFT(B2,2): the first two characters of Spain are Sp, not the suffix in.