Can't sort properly

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
 
D

Dave Peterson

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.)
 
Top