RIGHT, RIGHTB function
Summary
Returns the rightmost characters from a text value
Syntax
RIGHT(text,[num_chars])
The RIGHT function have the following arguments:
• Text Required. The text string containing the characters you want to extract.
• Num_chars Optional. Specifies the number of characters you want RIGHT to extract. 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.
• 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.
• Text Required. The text string containing the characters you want to extract.
• Num_chars Optional. Specifies the number of characters you want RIGHT to extract. 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.
• 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.
Example
=RIGHT(A2,5)
=RIGHT(A3)
=RIGHT(A3)