RIGHT (Primitive Spread Function) returns the rightmost characters from a text value.

SYNTAX:

RIGHT(Text, Num_chars)

REMARKS:

Arguments are as follows:

Argument Description 
Text Text string from which you want to return characters. 
Num_chars (Optional) Specifies the number of characters to return. 

The Text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

Note the following about the Num_chars argument:

• The Num_chars argument must be greater than or equal to zero.
  
• If the Num_chars argument is greater than the length of text, RIGHT returns all text.
  
• If the Num_chars argument is omitted, 1 is assumed. 

EXAMPLES:

RIGHT("Total Sales",5) equals Sales
RIGHT("Collie dog") equals g