What is RIGHT?
Extracts a specified number of characters from the end of a text string. Perfect for parsing suffixes, extensions, and trailing codes.
Syntax
=RIGHT(text, [num_chars])
Example
Formula: =RIGHT(A1, 4)
Result: 2025
How It Works
Returns the last 4 characters from text in A1. If A1 contains 'Report2025', result is '2025'. Default is 1 character if num_chars is omitted.