Returns the rightmost characters of a string.
Sample Usage
RIGHT("spreadsheet",5)
RIGHT(C5)
Syntax
RIGHT(text, [number])
- text - The string whose rightmost characters are returned.
- number - [OPTIONAL]The number of characters to return.
Examples
RIGHT("spreadsheet",5) returns five rightmost characters of the string - "sheet".
RIGHT(C5) returns the rightmost character of the string in C5.
Notes
- If number is omitted, it is assumed to be 1.
- number must be greater than or equal to zero.
- If number is greater than the length of text, RIGHT returns all of text .