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.