RIGHT
Returns the specified number of characters from the end of a text string
Syntax
RIGHT(text, [num_chars])
Parameters
- text: Required. The text string containing the characters you want to extract
- num_chars: Optional. The number of characters to extract (default 1)
Example
=RIGHT("Sale Price", 5)