sort wrong? a-1,a-10,a-11,a-2

  • Thread starter Thread starter me
  • Start date Start date
M

me

help with sorting right
i have a-1...c-16
i get
a-1,a-10,a-11..a16,a-2...
how do i get my sort to go a-1,a-2,a-3,,,a-10,a-11,a-
12...c-16
thanks me
 
It isn't really sorting wrong- it is sorting it like text,
you want the first bit sorted as text and the last bit
sorted as numbers. You could use =left(a1,2) and =mid
(a1,3,5) to split up the strings, take the value of the
last part, and have two sort keys.
Sorry, I can't explain it very well.
 
Back
Top