RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,num_chars)
Where:
Text is the text string containing the characters you want to extract. Num_chars specifies the number of characters you want RIGHT to extract.
Remarks
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.
Do It!
1. Open Excel Application
2. In Cell A1, type: Sale Price
3. In Cell B1, type: =RIGHT(A1,5)
4. Hit Enter and you should have a result as: Price
Explanation
With the above example, you extracted a String Value from Cell A1 to include all the 5 characters starting from right. Thus, from the whole string “Sale Price”, you get “Price”.
