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"

Related resources