Importing Text

[newbie78]

I have a product catalogue from my vendor and have an excel sheet which they have sent me. However, there are few changes that I need to make to it before I can import them back to my POS system. I saved the original excel file to a CSV file. Made the necessary changes and am trying to import it back to excel. HOwever, when I am trying to do that, for some reason the file is not importing right. The data which should be imported in one row, is being imported in several rows. I know I am not doing something right.

My text file looks like following:

20220,VEGETABLE OIL (6 X 96 OZ) ,CASE ,1,$26.00,$26.00; 
20076,CANOLA OIL (32.5 LBS),TIN ,1,$22.00,$22.00 ;
20075,CORN OIL (32.5 LBS),TINS,1,$22.00,$22.00 ;
19262,PEANUTS OIL (32.5 LBS),TINS,1,$35.00,$35.00 ;

I am trying to import this file using excel with comma delimiter. But the output is as follows:

a1---> 20220
b1 ---> Vegetable Oil (6x96 OZ)
b2--> Case
b3---> 1
c3---> $26.00
d3---> $26.00

Output wanted is as follows:
a1---> 20220
b1--> Vegetable Oil (6x96Oz)
c1-->Case
d1---> 1
e1--> $26.00
f1---> $26.00
And then go to the 2nd row

Any idea will be appreicated.

[TMS]

Works fine for me.

I copied the sample data into a text file and then used Data | From text to import the .txt file.

See the attached picture of the settings I used.

The only thing I can think of is that you have some new line characters in there somewhere but I'm not sure that would give the effect you're seeing. I'd have thought that would be noticeable if you viewed the file in, say, Notepad.

Perhaps you could upload part of the text file, edited if necessary, and a copy of the workbook you are trying to import it to.

Regards