How can I sort a list of numbers by the last 4 digits?

K

Kristin S

I am using Excel 2003. Can I sort a list of numbers by the last four digits?
There are apprximately 6 digits in each number.
 
E

Elkar

The easiest way would be to create a helper column and perform your sort
using that.

Let's assume your original data is in column A and your new helper column is
column B. In column B enter the formula:

=RIGHT(A1,4)

Copy down as needed. Then, when you sort, use Column B.

HTH
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep First Letters, with exceptions 0
Found few bugs in my daily routine of work in excel for MAC 0
Improving Macro That Keeps First Letter 0
Found few bugs in my daily routine of work in excel for MAC 0
Advanced Sort/ look 4
Truncating Number Series 3
Sorting or Filtering 5
How to count the numbers in a Word document? 0

Top