Right

Description

Obtains a specified number of characters from the end of a string.

Syntax

Right ( string, n )

Argument

Description

string

The string from which you want characters returned

n

A long whose value is the number of characters you want returned from the right end of string

Returns

String. Returns the rightmost n characters in string if it succeeds and the empty string (“”) if an error occurs.

If n is greater than or equal to the length of the string, Right returns the entire string. It does not add spaces to make the return value’s length equal to n.

Examples

Example 1

This expression returns HILL:

Right("CASTLE HILL", 4)

Example 2

This expression returns CASTLE HILL:

Right("CASTLE HILL", 75)

See also