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
<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
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