Skip to main content
Windward

LEFT Function

Overviewautotag-wiki-logo.png

The LEFT function

Returns the characters from the left of a text string, given a length.

For example,

=LEFT("AnyString", 7) return "AnyStri"

Syntax

LEFT(text,num_chars)
  • ​text - Required. String expression from which the leftmost characters are returned.
  • num_char - Required. Numeric expression indicating how many characters to return.
  • Was this article helpful?