Skip to main content



Returns a substring from the end of a specified string.

Sample Usage


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


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.

In order to use the RIGHT formula, start with your edited Excellentable







User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.