From your example, it looks like you can easily use TTC (Text To Columns),
which leaves actual data in the columns and not formulas, which may have to
be removed later.

Select the data, then, from the Menu Bar:
<Data <Text To Columns <Fixed Width <Next

Move the break line(s) as needed, then
<Finish

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bduncan" wrote in message
...
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