RIGHT
Returns the rightmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
What it does
Returns the rightmost characters from a text string.
Syntax
RIGHT(text, [num_chars])
Arguments
text(text) — Text to extract from.
Examples
Extract a suffix
Get the last 4 characters of A2.
FORMULA
=RIGHT(A2,4)
RESULT
1042
SAMPLE DATA
| A | |
|---|---|
| 1 | Code |
| 2 | INV-1042 |
| 3 | PO-0088 |