I am a relatively new excel user and have a problem with text in a cell not converting in tab delimited format how I want it to.
I am trying to upload a date feed to a site and have received an error report as follows-
"The text file you have uploaded has some errors. The problem is that some fields mainly product description spread on multiple rows.
You need to check and make sure that you remove the new line characters (\n) from every field before displaying the value of that field. "
I receive an excel products list from my supplier which has price,barcodes,sku's and product descriptions etc
I have attached an example, when opened in word or notepad it looks fine when opened in excel that is where the problem is
The product descriptions are contained in 1 cell and vary in length, when I edit this list to my preference and convert to tab delimited format for upload the product description is spread over many cells !
How can I resolve this without manually editing the gaps out of each product description?
I hope this makes sense to you
Thanks in advance