The RIGHT function in Excel returns the specified number of characters from the end of a text string.

The syntax of the RIGHT function is as follows:

RIGHT(text, [num_chars])

Where:

• Text (required) - the text string from which you want to extract characters.
• Num_chars (optional) - the number of characters to extract, starting from the rightmost character.
  • If num_chars is omitted, 1 last character of the string is returned (default).
  • If num_chars is greater than the total number of characters in the string, all characters are returned.
  • If num_chars is a negative number, a Right formula returns the #VALUE! error.

For example, to extract the last 3 characters from the string in cell A2, use this formula:

=RIGHT(A2, 3)