RIGHT returns the last characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,num_chars)
Text is the text string containing the characters you want to extract.
Num_chars specifies the number of characters you want RIGHT to extract.
Remarks
-
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.
Examples
F ormula |
Description (Result) |
---|---|
=RIGHT("Sale Price",5) |
Last 5 characters of the string (Price) |
=RIGHT("Stock Number") |
Last character of the string (r) |