How to Use Excel LEFT Function (Examples + Video)

Excel LEFT Function (Example + Video)

Excel LEFT Function

When to use Excel LEFT Function

LEFT function can be used to extract text from left of the string.

What it Returns

It returns the specified number of characters from the left of the string.

Syntax

=LEFT(text, [num_chars])

Input Arguments

  • text – The text string that contains the characters you want to extract.
  • [num_chars] – (optional) the number of characters to extract from the left of the text string. If you omit this, is defaults to 1.

Additional Notes

  • Num_chars must be greater than or equal to zero.
  • If num_chars is greater than the length of the text, LEFT returns all of text.
  • If the num_chars argument is not given, it returns the left-most character.
  • Spaces are counted as characters.
    • To remove extra spaces from text strings, use the TRIM function.
  • It also works with numbers, as it treats numbers as text (Live Example below).

Excel LEFT Function – Live Example

Excel LEFT Function – Video Tutorial

Related Excel Functions:

You May Find the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hey! I'm Sumit Bansal, founder of TrumpExcel.com and a Microsoft Excel MVP. I started this site in 2013 because I genuinely love Microsoft Excel (yes, really!) and wanted to share that passion through easy Excel tutorials, tips, and Excel training videos. My goal is straightforward: help you master Excel skills so you can work smarter, boost productivity, and maybe even enjoy spreadsheets along the way!

1 thought on “How to Use Excel LEFT Function (Examples + Video)”

  1. 112211_1_En_Aaaaaaaas
    I had to split above mentioned 1 cell value into two cells with the values
    112211_1_E one cell
    Aaaaaaaas another cell

    Reply

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster