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.

"Ruthhd" wrote:

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.

"bduncan" wrote:

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