1

I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).

Each one of the nubers if have 8-9 digits and I would like to sort this column by its last 3 digits (or create another column with the numbers sorted) (I would like that the last 3 digits of A_1 will be smaller or equal to those of A_2 etc')

Does anyone know of a way to do such a task ?

Note: I have Office 2010 installed.

Any help is greatly appreciated!

3
  • Is VBA out of the question?
    – Terry
    Apr 10, 2013 at 9:39
  • @djerry - what is VBA ?
    – Belgi
    Apr 10, 2013 at 10:00
  • basically, VBA can solve your problem without having to add additional columns/data to your sheet.
    – Terry
    Apr 10, 2013 at 15:17

1 Answer 1

7

Based on xl2007 (but I doubt differs for Office 2010):

In B1 enter =RIGHT(A1,3) and copy down as required. Copy ColumnB and Paste / Special / Values over the top. Sort ColumnA:B AZ with Sort by ColumnB.

1
  • 1
    +1, I double checked in XL2010 and it works fine.
    – dav
    Apr 10, 2013 at 12:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.