DoggettsBG
New Member
- Joined
- Apr 13, 2017
- Messages
- 7
I have a list of unit numbers for vehicles. Some are simple 1,2,3. Some are 16A, B-1, ME-1, FOB-1, etc. How can I format it to be in order. When I do the sort function it looks like this:
<colgroup><col></colgroup><tbody>
</tbody>
I need it to look like this:
<colgroup><col></colgroup><tbody>
</tbody>
Ive tried several formulas and either it sorts correct with the ones ending in "A" but makes it only go in order of the first number in the cell so 2 now comes after 19 etc. Or the other formula I used puts them in order with the 2 being after 3 but now all units with an "A" after are on the bottom
<colgroup><col></colgroup><tbody>
</tbody>
1 |
2 |
10 |
16 |
20 |
100 |
16a |
B-1 |
B-10 |
FB-1 |
FB-10 |
FB-12 |
FB-4 |
FOB-1 |
FOB-2 |
IN-1 |
IN-10 |
IN-12 |
IN-13 |
IN-20 |
ME-2 |
OR-6 |
PU-1 |
PU-OW2 |
SD-2 |
SF-1 |
V-1 |
<colgroup><col></colgroup><tbody>
</tbody>
I need it to look like this:
1 |
2 |
10 |
16 |
16a |
20 |
100 |
B-1 |
B-10 |
FB-1 |
FB-4 |
FB-10 |
FB-12 |
FOB-1 |
FOB-2 |
IN-1 |
IN-10 |
IN-12 |
IN-13 |
IN-20 |
ME-2 |
OR-6 |
PU-1 |
PU-OW2 |
SD-2 |
SF-1 |
V-1 |
<colgroup><col></colgroup><tbody>
</tbody>
Ive tried several formulas and either it sorts correct with the ones ending in "A" but makes it only go in order of the first number in the cell so 2 now comes after 19 etc. Or the other formula I used puts them in order with the 2 being after 3 but now all units with an "A" after are on the bottom
<colgroup><col></colgroup><tbody>
</tbody>