Text
Modern
RIGHT
Returns a given number of characters from the end of a text string.
Available in All versions
Syntax
RIGHT(text, [num_chars])What it returns
The rightmost characters of the text.
Arguments
| Argument | Required | Description |
|---|---|---|
text |
Yes | The text string. |
num_chars |
No | How many characters to return from the right (default 1). |
Example
F1
R2
-3
24
05
26
47
Result
2024
RIGHT returns the last N characters (here 4) from the end of the text.
=RIGHT(A2, 4)Important to know
num_chars defaults to 1 if omitted.
For variable-length extraction, combine with FIND or LEN.