How to use the LEFT Function in Excel

This function displays a specified number of characters from the left hand side of a piece of text.

     Syntax

=LEFT(OriginalText,NumberOfCharactersRequired)

No special formatting is needed.

ArgumentDescription
textThe text string from which you want to extract characters.
num_charsOptional. Specifies the number of characters to extract from the left side.
Note: If you omit num_chars, Excel considers it as 1.

 

  (Text)  (Formula)  (Result)
EXCEL2026=LEFT(A2,3)EXC
COMPUTER=LEFT(A3,4)COMP
PYTHON=LEFT(A4,2)PY
PYTHON=LEFT(A5)P
LEFT is a Text Function in Excel.
It is used to extract characters from the left side of a text string
1 is the default number of character
num_chars argument should be a positive number

If we use num_chars greater than text length, it will return complete text. 

A6 cell has value MOUSE, we use below formula.

=LEFT(A6,100) 

output will be MOUSE

It works on text, numbers & cell references.
5 FAQs for Excel LEFT Function
Q1. What is the LEFT function in Excel?
Ans:  LEFT is a Text Function in Excel. It is used to extract a specific number of characters from the left side (starting) of a text string. For example, =LEFT(“EXCEL2026”, 3) will return EXC.
Q2. What is the syntax of the LEFT function?
Ans:  The syntax is =LEFT(text, [num_chars])
– text:  The text string from which you want to extract characters. It can be text, number, or cell reference.
– num_chars:  The number of characters you want to extract from the left.[Optional]
Q3. What happens if I omit the num_chars argument?
Ans:  If you omit the num_chars argument, Excel considers it as 1 by default. So, =LEFT(“PYTHON”)  or =LEFT(A5) will return only the first character, which is P.
Q4. What if num_chars is greater than the total text length?
Ans:  If the num_chars is greater than the length of the text, LEFT will return the complete text. It will not give any error. For example, if text is “PY” and you use =LEFT(“PY”, 10), it will return “PY”.
Q5. Can LEFT function work on numbers?
Ans:  Yes. LEFT works on text, numbers & cell references. If you apply LEFT on a number like =LEFT(2026, 2), Excel will treat the number as text and return 20 as a text value. To use it again as a number, you need to wrap it with the VALUE function, like =VALUE(LEFT(2026,2)).
 
Scroll to Top