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])


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

formula returns "zard" as text value.

RIGHT Example 1

Example 2

formula returns "e". The RIGHT function returns the last character if [num_chars] argument is omitted.

RIGHT Example 2

Download Workbook


  • The 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.