RIGHT Function (VisioShapeSheet)

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

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

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

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.

RIGHT ("January 1, 2004", 4)

Returns the value 2004.

Show: