Sort Numbers

  • Thread starter Thread starter Sonya
  • Start date Start date
S

Sonya

I am trying to sort a 10 digit number by the last 6
digits...any ideas for me?
 
Hi Sonya

the only way i know is to use a "helper" column, in a column adjacent to
your current column type
=VALUE(RIGHT(A1,6))
where A1 is the cell reference of the first 10 digit number
and fill down

now sort (Data / Sort) using the helper column as the sort field & delete it
when finished

hope this helps
Cheers
JulieD
 
You must log in or register to reply here.

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

Sorting or Filtering 5
How can I sort a list of numbers by the last 4 digits? 2
Excel Sorting 4
How do I sort a column using the last number in the cell? 2
Aplpha Numeric Mixed Sorting 6
sort a cell by last two digits 4
Sorting data 2
Numbers to sort as text 5

Back
Top