Left

Returns the left part of a text value.

Variants

Left(Text text, Numeric number)

Returns the leftmost number of characters from the text argument.

Parameters

text
The text string that contains the characters you want to extract.
number
Specifies the number of characters you want to extract.

Returns

Text

Examples

Left(Text text, Text delimiter)

Returns the left part of a text value up to but not including the first occurrence of a delimiter value.

Parameters

text
The text string that contains the characters you want to extract.
delimiter
The delimiter string.

Returns

Text

Remarks

If the text does not include the delimiter, the entire text is returned.

Examples