← Back to level 1
Level 1Next
RIGHT
A easy text formula for pulling characters from the right side of a string.
Syntax
=RIGHT(...)Step-by-step explanation
- 1Pick the text cells or values that need to be combined or reformatted.
- 2Use the formula to extract, join, or format the text in the way you need.
- 3Press Enter and read the output as a cleaned-up label or string.
Common mistakes
Counting the wrong number of characters
Expecting it to work like LEFT
Ignoring trailing spaces
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=RIGHT(A1:B2)
Result
42
Worked example
- 1Inspect the source text in the sample table and decide what should change.
- 2Enter =RIGHT(A1:B2) to format, join, or extract the text.
- 3The final text result should read 42.
Practice area
Use RIGHT when the part you need appears at the end of text or a code.
Match against the syntax block above.