LEFT Function

About

LEFT function in Excel returns the given number of characters from the left side of a text string.

Function Type

Text

Purpose

Extract characters from the left side of a string.

Return value

Extracted characters.

Syntax

=LEFT(text, [num_chars])

Arguments

text – data from which characters are to be extracted.

num_chars – number of characters to be extracted. default value is 1.


Example


Notes

Number formatting is not a part of the text data. So, LEFT function will ignore $, % or any other characters displayed in cells using Number formatting in Excel.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel