Pinterest Pixel

Extracting Data with Excel’s LEFT Formula

What does it do? It returns the first character or characters in a text string, based on... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Extracting Data with Excel's LEFT Formula | MyExcelOnline Extracting Data with Excel's LEFT Formula | MyExcelOnline

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:

Extracting Data with Excel's LEFT Formula | MyExcelOnline

download excel workbook Left-1.xlsx

 

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

=LEFT

 

See also  ISNUMBER Formula in Excel

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

Extracting Data with Excel's LEFT Formula

 

[num_chars]

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

Enter a positive number only:

=LEFT(C9, 8)

Extracting Data with Excel's LEFT Formula

 

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:

Extracting Data with Excel's LEFT Formula

 

If you like this Excel tip, please share it
Extracting Data with Excel's LEFT Formula | MyExcelOnline Extracting Data with Excel's LEFT Formula | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...