seperating a column into two

[bduncan]

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

 

[RagDyeR]

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!
=====================================================

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

 

[Ruthhd]

make sure you have a blank columns next to the data. Select the data you
wish to separate and on the Data menu choose Text to columns. Choose the
Delimited option and click next. Place a check next to Other and type a dash
in the box - click Next. Unless you want to change the Data Format click
finish. This actually gives 3 an extra column because of the dash between the
two sets of part number. Simply align the numbers so they sit next to each
other and don't use a border line between them. Not perfect but it works.
However, I'll be checking your post to see if anyone has a more
straightforward way of doing it.

 

[Ruthhd]

Sorry back again, just remembered that if you use the fixed width option it
works much better. Sorry I don't use that option very ofen.