Sorting part numbers

markstro

Board Regular
Joined
Sep 8, 2008
Messages
106
Excel sorts by number placement, first digit, then by the second and so on. All part numbers starting with a one are sorted first, if the second digit is a one also, the next sequence will be all numbers with 11 as the first two digits so on & so on.

Is there any way to set the criteria to sort part numbers with 3 numbers first, then 4 numbers second, 5 numbers third etc.

Questions on my question, hoped I worded it well enough to give you an idea of what I am trying to do.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
I'm guessing that your part numbers are all numeric, but are formatted as text in your worksheet? But, basically, you want the sorting to behave as if they were numeric values? Are these assumptions correct?

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 23px"><COL style="WIDTH: 88px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>Text Sort</TD><TD> </TD><TD>Numeric Sort</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">11</TD><TD> </TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">111</TD><TD> </TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD style="TEXT-ALIGN: right">11</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: right">22</TD><TD> </TD><TD style="TEXT-ALIGN: right">22</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="TEXT-ALIGN: right">222</TD><TD> </TD><TD style="TEXT-ALIGN: right">33</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: right">3</TD><TD> </TD><TD style="TEXT-ALIGN: right">111</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="TEXT-ALIGN: right">33</TD><TD> </TD><TD style="TEXT-ALIGN: right">222</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: right">333</TD><TD> </TD><TD style="TEXT-ALIGN: right">333</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1

The solutions available depend on your data and how it's laid out.
 
Upvote 0
Our part numbers can be just numeric or alpha/numeric. We want them to sort as numeric values whether they have alpha characters or not.
Does this help??
 
Upvote 0
Okay, are the alpha charatcters always in the same place?

What are the limitations on the number of numbers and characters? (e.g. will the format always be a number up to 99999 followed by a maximum of four alpha characters?)

Maybe if you give examples of the possible permutations I can help you with a solution.
 
Upvote 0
How do I insert a file to a reply, will a hyperlink work to my directory work??

Unfortunately a hyperlink won't work unless it's in the public domain, and you can't embed a file in a reply.

You can, however, use one of the freely available tools to convert a sheet's contents to html, the source of which can be pasted into your post. Check out:

Colo's HTML Maker
http://puremis.net/excel/htmlmaker_faq.shtml

or Excel Jeannie
http://www.excel-jeanie-html.de/index.php?f=1

Or easier still, copy a list of the permutations as text in a reply.
 
Upvote 0
I had a utility that converted my cells to html. Hope this is what you are looking for. This is only a portion of the whole sheet.

<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0075-20 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TORQUE ARM 20" SOLID </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2090 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ADD WATER T-S </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2290 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">FLOP CHUTE MINI </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2404 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WATER TANK AIR VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2407 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WATER TANK PSI PROTECTION VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2413 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SITE TUBE VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">008-2988 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">DRUM CONTROL RAM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-0642 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CARRIAGE BOLTS FOR SLIDING MIXER PLATE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-112-4 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PYROMETER-BLACK BEZEL-HIGH P </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-1291 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WATER TANK VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-1294 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HYD TANK GATE VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-4960 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CHECK VALVE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0-10805-890-0 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">EXHAUST BOLT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-8555 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HYD BREATHER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">010-8576 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HYD COOLER ASSY </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01152M </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WATER TANK FLAPPER ASSY GASKETS </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">012-7503 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PTO OUTPUT FLANGE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-42093 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CROSSMEMBER END C </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-43117 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-43120 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-UPPER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-45151M000 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-EOF ALUM*Q </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-45909 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-LOWER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-46365 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSS TIE - ALUM - PETERBILT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47111 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSTIE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47112 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CROSSTIE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47368 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47609 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CROSSMEMBER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47626-001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-MIDSHIP CAB MTG </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-47627-002 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-MOUNTING CAB </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-4813-81 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SWITCH-TURN SIGNAL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-4814-71 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SWITCH-TURN SIGNAL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-48280M004 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BRACKET ASSY-FRAME AIR TRAC </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-48624L </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-LOWER STL LH </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-48624R </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-LOWER STL RH </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-49626 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CROSSTIE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-49627 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSTIE-RAISED STEEL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-001B </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">THERMOCOUPLE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-076 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">THERMOCOUPLE-HEWITT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51526-002 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL MIDSHIP/CAB M </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51526-003 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL MIDSHIP/CAB M </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51526-005 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL MIDSHIP/CAB M </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51526-006 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSS MEMBER - MIDSHIP - ALUM - PETERBILT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51526-007 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSS MEMBER - MIDSHIP - ALUM - PETERBILT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51527-003 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL SUSPENSION </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51527-007 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL SUSPENSION </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51528-006 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL SUSPENSION </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51565-001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSMEMBER-AL SUSP </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51612M000 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSS MEMBER - BRACKET - ALUM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51612M001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CAST ALUM XMBR </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-51797 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GUSSET-CROSSTIE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-52094 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSSTIE-STEEL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-2294 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CHUTE PIVOT SPACERS </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-52514 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SUPPORT-CROSSTIE ALUM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-52569 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CROSS TIE - STEEL - PETERBILT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-3252 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ATD WATER PIPE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-3359 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WASHOUT GUARD </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-3370 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">LOADING HOPPER STANDARD 93 MTM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">015-5130 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">LOADING HOPPER MTM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01-6970-74 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HARNESS-ASSY-SWITCH TURN SIG </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">018-3122 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CHUTE LOCK CHAMBER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">018-9155 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">JOYSTICK MOUNT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">019772X </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">COOLER-OIL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-100668 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NUTS </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-10437 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">REAR CONTROL HANDLE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-11236 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BOOSTER HOOK SPRINGS </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01374-100 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-FRONT AXLE 7/8-14NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01374-110 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-FRONT AXLE 7/8-14NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01374-120 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-FRONT AXLE 7/8-14NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01374-120-8 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U-BOLT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01374-12Y </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U-BOLT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01375-090 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-FRONT AXLE 3/4-16NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01375-100 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-FRONT AXLE 3/4-16NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-150425 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROLLER BOLT ASSY </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-16552 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CONTROL KNOBS GREEN </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-16553 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CONTROL KNOBS RED </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01701-060 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPACER DR </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01701-080 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPACER-FRONT SUSP ALUM </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01728 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPRING-FRONT 20K PROG </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01728C </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">LEAF SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01767 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PIN-STL FRONT SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01781 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PIN-STL FRONT SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01783 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SHACKLE-FRONT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01784 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SHACKLE-SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01801M003 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BRACKET-FRONT SPRING REAR ST </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01805 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BUSHING-SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01806 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPRING-FRONT TAPER 10K </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01807 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SHACKLE-SPRING DR </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-01847 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PIN-FRONT SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-02176 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">STUD-SHOCK MOUNT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-02311M001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BRACKET ASSY-SPRING REAR HAN </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-0237 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">STEER AXLE BUMP STOP </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-02736 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ABSORBER-SHOCK </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-02737 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SHOCK ABSORBER - LOAD LEVELER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-02904 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">STOP-BUMP FRONT SUSP </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-03115M001L </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BRACKET-FRONT SPRING FRONT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-03115M001R </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BRACKET-FRONT SPRING FRONT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-85426 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BOOSTER RAM THUMB PIN 2 PC TAPERED 2 1/2" O.D. </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-85427 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BOOSTER RAM THUMB PIN 2 PC TAPERED 2" O.D. </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-85428 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BOOSTER FRAME PIN LOCK RING SET SCREW </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">020-8544Z </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BOOSTER FRAME PIVOT PIN </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">021-6005 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROAD SPEED SENSOR </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-181H </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">STEER AXLE BUMP STOP </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-315169-3 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PUMP-F3V20P1S13T38C8H12 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">02-319023-7 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PUMP-POWER STEERING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01107 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U-BOLT SADDLE - LEAF SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01199 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WASHER-U BOLT REAR AXLE 3/4X </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01203 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WASHER-FLAT ROUND 1/16X7/8X5 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01568 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">DRIVE AXLE FLENSE GASKEG (PACCAR/PETERBILT) </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01653 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SEAT-SPRING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01654 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PIVOT-SPRING EYE AIR LEAF SU </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-01656 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPRING ASDDLE - DRIVE AXLE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-02174 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TORQUE ROD ALUMINUM W/O BUSHINGS (GAFF) </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-04059 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TORQUE ROD </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-04327 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TORQUE ROD </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-04516-155 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U-BOLT </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-04623 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">BUSHING </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-04951 M000 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">DRIVE AXLE BUMP STOP WELD ON BLOCK </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05105 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-SPRING EYE 3/4-16NFX3 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05108 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TORQUE ROD </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05110-155 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-AIR SUSP 1-14NSX3-9/1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05117 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPRING EYE </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05859M001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SEAT-AXLE FWD </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-05915 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">U BOLT-SPRING EYE 3/4-16NFX4 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-06212 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">VALVE-HEIGHT LH 9 INCH </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-06219 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">PAD-WEAR AIR TRAC SUSP </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-06684 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">VALVE- HEIGHT CONTROL </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-06748-002 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SPACER </font></td></tr>
<tr><td rowspan="1" colspan="1" width="240" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">03-06823M001 </font></td><td rowspan="1" colspan="1" width="720" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SEAT-AXLE AIR TRAC </font></td></tr>
</table>
 
Upvote 0
So, if I understand you correctly, most of your part numbers will start with a series of digits followed by a hyphen: ###-#####(-###-##) (with a couple of notable exceptions).

You want your initial sort of the data to be based on the number of digits before the first hyphen and then by the actual part number?
 
Upvote 0
Pretty much so, my shop managers are not excel savvy as well as computer savvy when it comes to how programs sort data.
It is counter intuitive to them.

If there is a way that the sort can come out the way a layman will logically expect it to appear, the easier it will be for them to look it up on the printout in the parts room.

This whole process is so a tech can find the part number he needs showing the parts bin location for easy retrieval.
 
Upvote 0
Try this....

If your part #'s are in column A and the description in column B you can put this formula in column C:
=FIND("-",A1&REPT(" ",255-LEN(A1))&"-")-1

Then select column A-C and using the Exel Sort; Sort by Column C Asc and then by Column A asc.

HTH
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top