RIGHT

Get a substring from the right of a specified string.

Parameter List

Syntax
RIGHT(string
[chars]
)
string

The string from which you want the right-side characters. For example: "Built with a spreadsheet" or B6.

[optional] chars

The number of characters to return from string. Must be greater or equal to 0. Zero returns an empty string. For example: 5. By default set to 1.

Examples

RIGHT(A1, 5) returns "erman",the last five characters of Superman (counting from the right).Example 1