Number sort is not correct

[MikeyZ]

I have a long list of numbers that aren't sorting correctly, can you help.

z0

z1

z10

z100

z101

z102

z103

z104

z105

z106

z107

z108

z109

z11

z110

<tbody>
</tbody><colgroup><col></colgroup>

I need them to sort :
z0
z1
z2
z3
etc.

 

[RoryA]

Those aren't numbers, they are text with a number suffix. You either need to separate the number parts into a separate column, or have them all formatted to the same length using leading zeroes in order to sort them numerically rather than alphanumerically.

 

[MikeyZ]

I finally figured it out. Found it in some previous notes from way back.
Had to insert a column and use =(RIGHT(B2,LEN(B2)-1))
Then I could sort.