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 Excel 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.



Examples

Example 1

=RIGHT(“Charizard”,4)
formula returns “zard” as text value.

RIGHT Example 1

Example 2

=RIGHT(“Blastoise”)
formula returns “e“. The Excel RIGHT function returns the last character if [num_chars] argument is omitted.

RIGHT Example 2

Download Workbook


Tips

  • Excel RIGHT function will not extract number formatting characters like currency symbols or thousand separators.
  • Try the LEFT function to return a sub-string from the right.
  • Try the MID function return a sub-string from the middle of a string.