athomemom20646
New Member
- Joined
- Jun 4, 2016
- Messages
- 2
Hello,
I have a spreadsheet of 22,600 items. I have a column that has a product ID number followed by a description. I need to remove the description and have just the ID number. My problem is product ID #'s are not all the same length. Is there a formula or an easy way to remove the unneeded text? Below is an example of some of the items. I need the numbers that are listed in front of the word Miller or even after the word Miller as they are the same #.
TIA Trish
[TABLE="width: 1070"]
<colgroup><col></colgroup><tbody>[TR]
[TD]11N19S Miller 11N19S INSULATOR, SLEEVE[/TD]
[/TR]
[TR]
[TD]121332 Miller 121332 CIRCUIT CARD ASSY,CONTROL MAIN[/TD]
[/TR]
[TR]
[TD]1215 Miller 1215 REMOTE ASSY, ALUMAPRO 15FT[/TD]
[/TR]
[TR]
[TD]1216 Miller 1216 REMOTE ASSY, ALUMAPRO 25 FT[/TD]
[/TR]
[TR]
[TD]1217 Miller 1217 REMOTE ASSY, ALUMAPRO 35FT[/TD]
[/TR]
[TR]
[TD]1223 Miller 1223 MOTOR,PISTOL PRO[/TD]
[/TR]
[TR]
[TD]1239 Miller 1239 HEAD TUBE,(A) PISTOL PRO 180 DEG 4 IN[/TD]
[/TR]
[TR]
[TD]1244 Miller 1244 HARDWARE KIT,LINER/TIPS - PISTOL PRO[/TD]
[/TR]
[TR]
[TD]124425 Miller 124425 CIRCUIT CARD ASSY,MOTOR CONTROL[/TD]
[/TR]
[TR]
[TD]1245 Miller 1245 CABLE,CONTROL 25 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]124511 Miller 124511 SWITCH,TGL DPST 40A 600VAC SCR TERM[/TD]
[/TR]
[TR]
[TD]1246 Miller 1246 CABLE,CONTROL 35 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]1254 Miller 1254 HEAD TUBE,(W) PISTOL PRO 180 DEG 4 IN[/TD]
[/TR]
[TR]
[TD]125630 Miller 125630 CIRCUIT CARD ASSY,HALL BOOST[/TD]
[/TR]
[TR]
[TD]125S20 Miller 125S20 WELDCRAFT BOOT, INSULATOR, 2" (50.8MM)[/TD]
[/TR]
[TR]
[TD]1269 Miller 1269 CABLE,CONTROL 15 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]126984 (3) Miller 126984 BRUSH W/SPRING (3)[/TD]
[/TR]
[TR]
[TD]1272 Miller 1272 LINER,TEFLON .030-.035 WIRE 4IN PP (FASTIP)[/TD]
[/TR]
[TR]
[TD]1273 Miller 1273 LINER,TEFLON .047-.062 WIRE 4IN PP (FASTIP)[/TD]
[/TR]
[TR]
[TD]1274 Miller 1274 #008 SILICONE O-RING (FOR DRIVE ASSEMBLIESS)[/TD]
[/TR]
[TR]
[TD]128077 Miller 128077 KIT,PUMP REPAIR 134120 PUMP[/TD]
[/TR]
[TR]
[TD]1295 Miller 1295 CABLE,XR-35A PISTOL PRO W/REMOTE[/TD]
[/TR]
[TR]
[TD]12GG Miller 12GG WELDCRAFT INSULATOR, GAS LENS[/TD]
[/TR]
[TR]
[TD]1325 Miller 1325 CABLE COVER FOR REMOTE,A/C LEATHER W/VELCRO 35 FT[/TD]
[/TR]
[TR]
[TD]134082 Miller 134082 DVD,GMAW TRANSFER (8 MIN)[/TD]
[/TR]
[TR]
[TD]135184 Miller 135184 DIODE BOARD,[/TD]
[/TR]
[TR]
[TD]135426B Miller 135426B TIP,CONTACT .062/73 (BULK)[/TD]
[/TR]
[TR]
[TD]1358 Miller 1358 LEVER,ARM ASSY PISTOL PLUS/PRO[/TD]
[/TR]
[TR]
[TD]136273 Miller 136273 CIRCUIT CARD ASSY,BATTERY CHARGER[/TD]
[/TR]
[TR]
[TD]1364 Miller 1364 HEAD TUBE ASSY,(A) PISTOL PRO LINER 60 DEG 6 IN[/TD]
[/TR]
</tbody>[/TABLE]
I have a spreadsheet of 22,600 items. I have a column that has a product ID number followed by a description. I need to remove the description and have just the ID number. My problem is product ID #'s are not all the same length. Is there a formula or an easy way to remove the unneeded text? Below is an example of some of the items. I need the numbers that are listed in front of the word Miller or even after the word Miller as they are the same #.
TIA Trish
[TABLE="width: 1070"]
<colgroup><col></colgroup><tbody>[TR]
[TD]11N19S Miller 11N19S INSULATOR, SLEEVE[/TD]
[/TR]
[TR]
[TD]121332 Miller 121332 CIRCUIT CARD ASSY,CONTROL MAIN[/TD]
[/TR]
[TR]
[TD]1215 Miller 1215 REMOTE ASSY, ALUMAPRO 15FT[/TD]
[/TR]
[TR]
[TD]1216 Miller 1216 REMOTE ASSY, ALUMAPRO 25 FT[/TD]
[/TR]
[TR]
[TD]1217 Miller 1217 REMOTE ASSY, ALUMAPRO 35FT[/TD]
[/TR]
[TR]
[TD]1223 Miller 1223 MOTOR,PISTOL PRO[/TD]
[/TR]
[TR]
[TD]1239 Miller 1239 HEAD TUBE,(A) PISTOL PRO 180 DEG 4 IN[/TD]
[/TR]
[TR]
[TD]1244 Miller 1244 HARDWARE KIT,LINER/TIPS - PISTOL PRO[/TD]
[/TR]
[TR]
[TD]124425 Miller 124425 CIRCUIT CARD ASSY,MOTOR CONTROL[/TD]
[/TR]
[TR]
[TD]1245 Miller 1245 CABLE,CONTROL 25 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]124511 Miller 124511 SWITCH,TGL DPST 40A 600VAC SCR TERM[/TD]
[/TR]
[TR]
[TD]1246 Miller 1246 CABLE,CONTROL 35 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]1254 Miller 1254 HEAD TUBE,(W) PISTOL PRO 180 DEG 4 IN[/TD]
[/TR]
[TR]
[TD]125630 Miller 125630 CIRCUIT CARD ASSY,HALL BOOST[/TD]
[/TR]
[TR]
[TD]125S20 Miller 125S20 WELDCRAFT BOOT, INSULATOR, 2" (50.8MM)[/TD]
[/TR]
[TR]
[TD]1269 Miller 1269 CABLE,CONTROL 15 FT (PISTOL PRO)[/TD]
[/TR]
[TR]
[TD]126984 (3) Miller 126984 BRUSH W/SPRING (3)[/TD]
[/TR]
[TR]
[TD]1272 Miller 1272 LINER,TEFLON .030-.035 WIRE 4IN PP (FASTIP)[/TD]
[/TR]
[TR]
[TD]1273 Miller 1273 LINER,TEFLON .047-.062 WIRE 4IN PP (FASTIP)[/TD]
[/TR]
[TR]
[TD]1274 Miller 1274 #008 SILICONE O-RING (FOR DRIVE ASSEMBLIESS)[/TD]
[/TR]
[TR]
[TD]128077 Miller 128077 KIT,PUMP REPAIR 134120 PUMP[/TD]
[/TR]
[TR]
[TD]1295 Miller 1295 CABLE,XR-35A PISTOL PRO W/REMOTE[/TD]
[/TR]
[TR]
[TD]12GG Miller 12GG WELDCRAFT INSULATOR, GAS LENS[/TD]
[/TR]
[TR]
[TD]1325 Miller 1325 CABLE COVER FOR REMOTE,A/C LEATHER W/VELCRO 35 FT[/TD]
[/TR]
[TR]
[TD]134082 Miller 134082 DVD,GMAW TRANSFER (8 MIN)[/TD]
[/TR]
[TR]
[TD]135184 Miller 135184 DIODE BOARD,[/TD]
[/TR]
[TR]
[TD]135426B Miller 135426B TIP,CONTACT .062/73 (BULK)[/TD]
[/TR]
[TR]
[TD]1358 Miller 1358 LEVER,ARM ASSY PISTOL PLUS/PRO[/TD]
[/TR]
[TR]
[TD]136273 Miller 136273 CIRCUIT CARD ASSY,BATTERY CHARGER[/TD]
[/TR]
[TR]
[TD]1364 Miller 1364 HEAD TUBE ASSY,(A) PISTOL PRO LINER 60 DEG 6 IN[/TD]
[/TR]
</tbody>[/TABLE]