?
Solved

extract last 5 digits in a excel column

Posted on 2013-01-11
2
Medium Priority
?
613 Views
Last Modified: 2013-01-11
Hi,

I have a column in excel with following format:

Column A
this is a test1 - 12345
this is a test2 - 12456
this is a test3 - 11234
this is a test4 - 13789
.
.

I need to extract the last 5 digits of each row which will be the 5 digit number and put in column B for some data manipulation. How can I do this in excel? is there a forumula you can provide for this?

Thanks,
0
Comment
Question by:shland
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 1000 total points
ID: 38768336
=right(a1,5)
0
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 1000 total points
ID: 38768337
Try:

=RIGHT(A1,5)+0
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question