LEFT Function

Description

Returns the leftmost characters from a text string.

NOTES

• The number of characters to return is specified by num_chars.
  If num_chars is omitted, LEFT returns the first character of the text.

Syntax

Copied!=LEFT(text, [num_chars])
=LEFT(text, [num_chars])

SAMPLE-1

EXAMPLE 1.1

Copied!=LEFT(A2:A6, 3)
=LEFT(A2:A6, 3)

RELATED POST