Left
The Left function returns the leftmost character or characters in a text string.
Usage:
= Left(<text> [, <num_chars>]);
<Text> is the text string containing the characters you want to extract.
<Num_chars> specifies how many characters you want the function to return. If <num_chars> is omitted, it is assumed to be 1. <Num_chars> must be positive or omitted.
Examples:
/* Returns 'Hello'
= Left("Hello World", 5);
/* Returns 'H'
= Left("Hello World");