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
Relevant topics
Split String to Left [SPLITLEFT]
Splits a string into parts at a given delimiter.
Returns the specified part and all parts to its left.
Syntax
SPLITLEFT (“Text”, ...
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position.
Syntax
REPLACE ...
Convert to String [STR]
Converts a non-unit numeric value or a True/False value into a string.
The resulting string shows two decimal places by default.
Syntax
...