Importing Text

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Any idea will be appreicated.

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