
Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)