Right() |
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" |