What is the RIGHT Function
The RIGHT function returns the last N characters from a text string, starting from the right. It is useful for extracting suffixes, years, extensions, and any fixed-position text from the end.
Formula: =RIGHT(text, [num_chars])
Practical Example 1
A2 contains EXCEL2024.
Type: =RIGHT(A2, 4)
Result: 2024
Practical Example 2
Extract the last 2 digits of a year.
Type: =RIGHT(A2, 2)
Result: 24
Practical Example 3
Get a file extension.
Type: =RIGHT(A1, LEN(A1) - FIND(., A1))
Result: the file extension
Practical Example 4
Extract a suffix after a dash.
Type: =RIGHT(A2, LEN(A2) - FIND(-, A2))
Result: the text after the dash
When to Use It
RIGHT is used for extracting years, for getting file extensions, for parsing suffixes from codes, and for any situation where you need the last part of a text string.