RIGHT Function

Returns the rightmost characters from a text string.
Sample Usage
RIGHT("Hello World", 3)
Syntax
RIGHT(
  • text
  • [
    num_chars
    ]
)
  • text
    —
    The text containing the characters to return.
  • num_chars
    —[optional]
    Starting from the rightmost character, the number of characters to return. If a number isn’t provided, only the first character from the right will be returned.
Usage Notes
  • With right-to-left languages (such as Arabic), RIGHT will return the leftmost characters instead.
Related Functions
LEFT
MID
REPLACE
SUBSTITUTE
FIND
Was this article helpful?
YesNo