This documentation is archived and is not being maintained.
LEFT Function (VisioShapeSheet)
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Syntax
Remarks
Example
Returns the left-most character or characters in a text string, based on the number of characters you specify.
LEFT(text, [,num_chars_opt])
Parameters
|
Name
|
Required/Optional
|
Data Type
|
Description
|
|
text
|
Required
|
String
|
The text string that contains the characters you want to extract.
|
|
num_chars_opt
|
Optional
|
Numeric
|
The number of characters you want to extract.
|
Return Value
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, LEFT returns all of the text. If num_chars_opt is omitted, it is assumed to be 1.
LEFT ("January 1, 2004", 3)
Returns the value "Jan".