Kazam Trainings

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

Description

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.

Syntax

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)
Example:
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.