RIGHT

Returns a substring from the end of a specified string.

Sample Usage

RIGHT(A2,2)

RIGHT("lorem ipsum")

Syntax

RIGHT(string, [number_of_characters])

  • string - The string from which the right portion will be returned.

  • number_of_characters - [ OPTIONAL - 1 by default ] - The number of characters to return from the right side of string.

Notes

  • 0 is a valid input for number_of_characters and will cause RIGHT to return the empty string.

See Also

SUBSTITUTE: Replaces existing text with new text in a string.

SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

MID: Returns a segment of a string.

LEFT: Returns a substring from the beginning of a specified string.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
17490831551458826648
true
Search Help Center
true
true
true
true
true
35
false
false