Pinterest Pixel

Extracting Data with Excel’s RIGHT Formula

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

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Extracting Data with Excel's RIGHT Formula | MyExcelOnline

What does it do?

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

Formula breakdown:

=RIGHT(text, [num_chars])

What it means:

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


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

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

In our example below, we have an address which has a zip code at the end (the zip code is fixed at 5 characters long) and we want to extract all of the zip codes in our address list.

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 RIGHT Formula | MyExcelOnline

download excel workbook Right.xlsx

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

=RIGHT

 

See also  MEDIAN Formula in Excel

STEP 2: The Right arguments:

text

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

Reference the cell that contains the text or value:

=RIGHT(C9

Extracting Data with Excel's RIGHT Formula

[num_chars]

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

Enter a positive number only:

=RIGHT(C9, 5)

Extracting Data with Excel's RIGHT Formula

 

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

Notice all of the last 5 characters in each text are now extracted:

Extracting Data with Excel's RIGHT Formula

 

 

 

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

Extracting Data with Excel's RIGHT 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!