Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the RIGHT function.
Description
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,[num_chars])
The RIGHT function has the following arguments:
- text - Required. The text string containing the characters you want to extract.
- num_chars - Optional. Specifies the number of characters you want RIGHT to extract.
- num_chars must be greater than or equal to zero.
- If num_chars is greater than the length of text, RIGHT returns all of text.
- If num_chars is omitted, it is assumed to be 1.
Example
| Formula | Description | Result |
| =RIGHT({variable}, 5) | Last 5 characters of the variable (assuming the text represented is"Sales price") | price |
| =RIGHT(Sales price) | Last character of the string | e |
Errors
For a full list of formula errors, please read Formula errors.