RIGHT function

RIGHT returns the last characters in a text string, based on the number of characters you specify.



Text     is the text string containing the characters you want to extract.

Num_chars     specifies the number of characters you want RIGHT to extract.


  • Num_chars must be greater than or equal to zero.

  • If num_chars is greater than the length of text, RIGHT returns all of text.

  • If num_chars is omitted, it is assumed to be 1.


F ormula

Description (Result)

=RIGHT("Sale Price",5)

Last 5 characters of the string (Price)

=RIGHT("Stock Number")

Last character of the string (r)

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!