sorting numbers

[DDon]

i have a list of numbers, 3A-1 thru 3A-30. When I sort my numbers on my table, 3A-10 would be behind 3A-1 instead of 3A-2. How do I sort my column so all numbers will fall in order.

Thanks

Excel 2010

	L
2	3A-1
3	3A-10
4	3A-11
5	3A-12
6	3A-13
7	3A-14
8	3A-15
9	3A-16
10	3A-17
11	3A-18
12	3A-19
13	3A-19
14	3A-19
15	3A-2
16	3A-2
17	3A-20

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

AB900​

 

[jamtay317]

put 3a-01
3a-02
and so on all the way to 10

 

[DDon]

I have to keep the zeros out

 

[danzon]

use a helper column. If your first line of numbers is in row 3, then in C3 enter the formula

=RIGHT(B3,LEN(B3)-FIND("-",B3))*1

drag that down and then sort on that new column

 

[jamtay317]

you can put a space instead of the zero

 

[DDon]

perfect thank you

Don