RIGHT Function (VisioShapeSheet)

Returns the last character or characters in a text string, based on the number of characters you specify.

Syntax

RIGHT(text [, num_chars_opt ])

Parameters

Name Required/Optional Data Type Description
text
Required
String
The text string containing the characters you want to extract.
num_chars_opt
Optional
Number
The number of characters you want to extract. The default is 1.

Return value

String

Remarks

The value of num_chars_opt must be greater than or equal to zero (0).

If num_chars_opt is greater than the length of the text, RIGHT returns all of the text. If num_chars_opt is omitted, it is assumed to be 1.

Example

RIGHT ("January 1, 2004", 4)

Returns the value 2004.