String from Left [LEFT]

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

  • Was this Helpful ?
  • YesNo
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 ...