Returns a specified number of characters from the start of a text string.
Syntax
LEFT (“Text”, NumberOfCharacters)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Text: String
Number of Characters: Integer
Data Type of the Result
String
Example
Starting at the left end of the given text string, return the first nine characters.
Expression
LEFT (“The quick brown fox”, 9)
Result
The quick