Can't sort properly

  • Thread starter Thread starter Ken Jeffery
  • Start date Start date
K

Ken Jeffery

Hi All
Just trying to sort some data that starts with a letter,
according to Microsoft it sorts A1, then A100, then A11,
obviously this is not right, but thats how it works, is
there any way I can get either Excell or Access to sort
it correctly.
Ken
 
Maybe you could insert a helper column and sort by that:

=LEFT(A1)&TEXT(MID(A1,2,255),"0000")

(If A11 is in cell A1, then you'll see A0011 in that helper cell.)
 
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

Real-time sorting 11
Alpha sorting (with a twist...?) 3
Columns not sorting properly. 2
sorting oddity 1
Sorting several columns 1
Sorting formula cells not same as sort of value cells? Yikes! 4
writing a sort macro 2
Specific sort order 5

Back
Top