Returns a substring from the end of a specified string.

Sample Usage


RIGHT("lorem ipsum")


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.


  • 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.


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.

Clear search
Close search
Google apps
Main menu