Right()

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Text Functions > Right()

 

RIGHT() returns a specified number of characters from a string, starting with the right-most character. If the specified length exceeds the length of the string, the entire string is returned.

 

 

Function Format

 

RIGHT(string, length) 

 

 

Return Value

 

RIGHT() returns a character string 

 

 

Examples

 

RIGHT("APPLES AND ORANGES", 7) = "ORANGES" 

 

RIGHT("APPLES AND ORANGES", 11) = "AND ORANGES" 

 

RIGHT("APPLES AND ORANGES", 20) = "APPLES AND ORANGES"