The RIGHT function
Returns the last characters of a text. The result is text, even when it looks like a number.
Syntax
RIGHT(text, [num_chars])- text
- The text to take characters from.
- num_chars (optional)
- How many characters to return. Default 1.
Examples
C1
=RIGHT(1A2,24)| A | B | C | |
|---|---|---|---|
| 1 | Code | 2100 | |
| 2 | DK-2100 |
In plain words: Take 2the last 4 characters of 1the code in A2.
C1=RIGHT(A2)
| A | B | C | |
|---|---|---|---|
| 1 | Code | 0 | |
| 2 | DK-2100 |