RIGHT

  • Updated

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 .