Right
The Right function returns a substring from the end of a string. This substring will be the last n characters of the string, where n is the argument number.
This is useful to extract a relevant piece of a string that is at the end with a constant length.
Usage
Right(text, number)
text (required)- The string from which a right substring will be returned
number (required)- The desired length of the returned substring.
Examples
Right(“Jane Doe”, 5)
- Returns: “e Doe”
Right("Apartment 217",3)
- Returns: "217"