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