The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the RIGHT function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
Excel RIGHT Function Syntax
RIGHT(text, [num_chars])
Arguments
text | The text that contains the sub-string you want to extract. |
[num_chars] | Optional. The number of characters you want to extract. |
Excel RIGHT Function Examples
Example 1
=RIGHT("Charizard",4)
Example 2
=RIGHT("Blastoise")