A to Z of Excel Functions: The RIGHT Function
11 November 2024
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the RIGHT function.
The RIGHT function

The RIGHT function returns the last character or characters in a text string, based upon the number of characters specified.
The RIGHT function employs the following syntax to operate:
RIGHT(text, [number_of_characters])
The RIGHT function has the following arguments:
- text: this is required and represents the text string that contains the characters you want to extract
- number_of_characters: this argument is optional and specifies the number of characters from the end you want RIGHT to extract.
It should be further noted that:
- number_of_characters must be greater than or equal to zero
- if number_of_characters is greater than the length of text, RIGHT returns all of text
- if number_of_characters is omitted, it is assumed to be one (1).
Please see my examples below:

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.
A full page of the function articles can be found here.