Excel Function RIGHT

RIGHT(text [,num_chars])

Returns the last or right most characters in a text string.

text	The text string that contains the characters you want to extract.
num_chars	(Optional) The number of characters you want to extract.

Remarks

* If "text" is a text string then it must be enclosed in speech marks.
* The "text" can be numbers.
* The "text" can be cell reference.
* If "num_chars" > the length of the "text", then "text" is returned.
* If "num_chars" is left blank, then 1 is used.
* If "num_chars" is not numerical, then #VALUE! is returned.
* If "num_chars" < 0, then #VALUE! is returned.
* Any blank spaces are counted as individual characters.
* If more than one cell is referenced then a Dynamic Array Formula will be applied.
* You can use the LEFT function to return the first or left most characters in a text string.
* You can use the TRIM function to return a text string with all spaces removed from the beginning, middle and end.
* You can use the RIGHTB function if you have languages that use the double-byte character set.
* For the Microsoft documentation refer to support.office.com

	A
1	=RIGHT("Better Solutions",9) = Solutions
2	=RIGHT("Better",1) = r
3	=RIGHT("Solutions",1) = s
4	=RIGHT("Be More Productive",15) = More Productive
5	=RIGHT("Be More Productive",100) = Be More Productive
6	=RIGHT("word ",5) = "word "
7	=RIGHT(TRIM("word "),5) = word
8	=RIGHT(BetterSolutions,5) = #NAME?
9	=RIGHT("Better Solutions",-50) = #VALUE!
10	=RIGHT("Better Solutions","Be More Productive") = #VALUE!