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) 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.
|2||A10-020 Furniture & Fixture||=RIGHT(A2, 19)||Furniture & Fixture|