I have a large text file of product descriptions by part number that I got from my distributor. I need to bring it into Excel and save it as a csv file.
After the first try, I discovered that Excel had cut short the descriptions on a lot of products. It didn't have to do with the length of the description, as some products had many sentences, and others got cut off after one or two. It must have something to do with the formatting of the text file.
I looked at the text file, and the full descriptions are there. I tried using an existing csv file with long descriptions, eliminating all but three or four rows just to make it manageable, and then importing the product description text file. It still cut off the descriptions, and on the same products. It's the same ones each time.
Does anyone have any idea as to what the problem might be, and if there's a way to solve it?