Home/Formulas/Text/RIGHT
Texteasy

RIGHT()

Returns a substring from the end of a specified string.

Syntax
fx
=RIGHT(string, [number_of_characters])
Try it
F2
→
tech
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Like LEFT, counts from the END of the string by character count, not byte count.
  • If the requested length exceeds the string, RIGHT returns the entire string: no error, no padding.
Related formulas
LEFT()
Returns a substring from the beginning of a specified string.
MID()
Returns a segment of a string starting at a given position, for a given length.
Used by
LEFT()
Returns a substring from the beginning of a specified string.
LEN()
Returns the number of characters in a string.
MID()
Returns a segment of a string starting at a given position, for a given length.
More Text formulas →Keyboard shortcuts for Sheets →