These docs are for v1.0. Click to read the latest docs for v1.2.

RIGHT

Returns the specified number of characters from the end of the string.

Syntax

=RIGHT(string, count)

Arguments

ArgumentTypeDescription
stringStringThe string to get characters from
countNumberThe number of characters to get

Examples

=RIGHT("ABCDEF", 2)"EF"
Gets the last 2 characters from the string "ABCDEF"

=RIGHT("GHIJKL", 1)"L"
Gets the last character from the string "GHIJKL"

=RIGHT("MNOPQR", 0")#ERROR!
Gets the last 0 characters from the string "MNOPQR" (returns an error because the number of characters must be greater than or equal to 1