| |||||
| |||||
RIGHT returns the last characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,num_chars)
Text is the text string containing the characters you want to extract.
Num_chars specifies the number of characters you want RIGHT to extract.
Remarks
Example
| Formula | Description (Result) |
|---|---|
| =RIGHT("Sale Price",5) | Last 5 characters of the string (Price) |
| =RIGHT("Stock Number") | Last character of the string (r) |