What does it do?

It returns the first character or characters in a text string, based on the number of characters you specify.

Formula breakdown:

=LEFT(text, [num_chars])

What it means:

=LEFT(look in this cell, extract X characters)


There are times when you will need to extract the first few characters of text within a cell, e.g. From a serial number, part number, name, phone number etc.

The LEFT formula in Excel can help you parse and extract the needed text easily.

In our example below, we have a Part # which has 10 characters and we want to extract all the characters before the hyphen “-“.

I explain how you can do this and please go to the bottom of the page to see the animated gif tutorial:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: We need to enter the Left function next to the cell that we want to extract the data from:

=LEFT

 

STEP 2: The Left arguments:

text

Which text do we want to extract the first X characters from?

Reference the cell that contains the text or value:

=LEFT(C9

1st argument

 

[num_chars]

How many characters do we want to extract from cell C9?

Enter a positive number only:

=LEFT(C9, 8)

2nd argument

 

STEP 3: Do the same for the rest of the cells by dragging the LEFT formula all the way down using the left mouse button.

Notice all of the first 8 characters in each text are now extracted:

Left 03

Left

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Cleaning Data with Excel’s TRIM Formula What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula breakdown: =TRIM(text) What it means: =TRIM(text that you want extra spaces to be removed) In the quest for cleaner data, one of the common scenarios is remo...
10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga. There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post will look at 10 rounding functions of Excel, and then look at some formatting te...
CountBlank Formula in Excel What does it do? Counts the number of cells that are blank Formula breakdown: =COUNTBLANK(range) What it means: =COUNTBLANK(range of cells to check) Do you have a scenario where you want to count the number of cells that are blank in your Excel data? If y...
Change Phone Area Codes with Excel’s REPLACE Formu... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...