Sorting by first digit ex... 1,11,123,2,21,212,3,32,323 etc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers that I want to sort by the first digit. What is
the best way to accomplish this?
 
Hi
in an adjacent cell put
=LEFT(A1,1)
and sort with this helper column
 
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

sort a cell by last two digits 4
How do I sort a column using the last number in the cell? 2
Excel Sorting 4
Sorting or Filtering 5
How do I sort by the first digit of a number? 7
Aplpha Numeric Mixed Sorting 6
How can I sort a list of numbers by the last 4 digits? 2
News Bank of England considers digital currency 4

Back
Top