Return a given number of characters from the end of a text string.
Syntax
RIGHT(text, [num_chars])Arguments
textrequired
The text to extract from.
num_charsoptional
How many characters to return (default 1).
RIGHT extracts characters from the right of a string — handy for suffixes, last digits, or file extensions. Pair with LEN and FIND for dynamic extraction.
=RIGHT("INV-2026-0042", 4)→0042Returns the last 4 characters.
Point at the text
Reference the cell holding the string.
Set the count
Specify how many trailing characters to keep.
Combine RIGHT with FIND, or use TEXTAFTER in newer Excel: =TEXTAFTER(A2, ".", -1).