RIGHT Function

Written by kazamraza no comments
Classified in : Excel Formulas, Text Functions Tags : none

This article describes the formula syntax and usage of the RIGHT function in Microsoft Excel.


RIGHT returns the last character or characters in a text string, based on the number of characters you specify. The RIGHT is also used for standardization of data.


RIGHT(text, [num_chars])
text is your cell reference and
[num_chars] is number of characters to be extratcted.

or in plain english the RIGHT function means

RIGHT(from this text, this many letters)
RIGHT("A10-020 Furniture & Fixture", 19) = Furniture & Fixture
Note: Space in characters is also counted as a character.

The function syntax has the following arguments:

  • Text Required. The text string that contains the characters you want to extract.
  • Num_chars Optional. Specifies the number of characters you want RIGHT to extract.
    • Num_chars must be greater than or equal to zero.
    • If num_chars is greater than the length of text, RIGHT returns all of text.
    • If num_chars is omitted, it is assumed to be 1.


1 Data Formula Result    
2 A10-020 Furniture & Fixture =RIGHT(A2, 19) Furniture & Fixture    
3 35202-2485132-3 =RIGHT(A2) 3