sort by the last 2 digits

G

georgeawwad

I have a long column of 5 digit numbers, i need to sort the column b
the last two digits, can it be done :confused: :confused
 
F

Frank Kabel

Hi
use a helper column with the formula
=RIGHT(A1,2)
copied down for all rows and sort with this column
 

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

Loop 1
Sorting in Excel 4
duplicate numbers in a column 2
Sorting or Filtering 5
How can I sort a list of numbers by the last 4 digits? 2
Excel Sorting 4
Copy and Paste Help 2
VBA Macro change column contents 4

Top