Right
Returns the right part of a text value.
Variants
Right(Text text, Numeric number)
Returns the rightmost number of characters from the text argument.
Parameters
- text
- The text string that contains the characters you want to extract.
- number
- Specifies the number of characters you want to extract.
Returns
Text
Examples
Right("typeAA1", 3)returns "AA1".
Right(Text text, Text delimiter)
Returns the right part of a text value starting at the character after the last occurrence of a delimiter value.
Parameters
- text
- The text string that contains the characters you want to extract.
- delimiter
- The delimiter string.
Returns
Text
Remarks
If the text does not include the delimiter, the entire text is returned.
Examples
Right("John Smith", " ")returns "Smith".Right("test/AA1", "/")returns "AA1".Right("test/AA1", ";")returns "test/AA1".