| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
seperating a column into two
I exported our number inventory to excel and it didn't seperate the inventory
numbers and descriptions is there a way that I can do this? I need to seperate at the dash between the description and part number. 239-314055 - HOSE HIGH PRESSURE 939-16 FEM JIC SWIVAL FITTINGS BOTH END 4 FT LENGHTS 1000 PS 58.00 239-503017 - BULKHEAD BOLTED FITTING 2" W/SIPHON 1.00 240-700100 - NIPPLE 1/4" X CLOSE SCH 80 PVC 10.00 240-700101 - NIPPLE 1 1/2" X CLOSE SCH 80 PVC 38.00 240-700102 - BUSHING 1/2" MPT X 1/4 FPT THDXTHD SCH80 PVC 22.00 240-700103 - NIPPLE 1" X CLOSE SCH 80 PVC 10.00 240-700104 - NIPPLE 3/4" X CLOSE SCH 80 PVC 14.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seperating Text from Columns | Excel Discussion (Misc queries) | |||
| Seperating buy Tabs | Excel Worksheet Functions | |||
| Seperating text | Excel Discussion (Misc queries) | |||
| Seperating First and Last Names | Excel Discussion (Misc queries) | |||
| Seperating worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
