Does anyone have a trick to get out line breaks and html out of a excel spread sheet? Something like a find and replace for removing html/blank lines.
Thanks All
Alex

I'm not sure what formatting you want to retain but I always paste things in Notepad first to remove any markup language. Will that work?

You can also right click in the cell you going to paste too and selct "Past Special" it will allow you to paste your copy as text.

Thanks for the help, this is whats going on.

I export my 2000 products to a csv from dataport. But in my detailed description I have line breaks, and some html. For me to be able to upload this datafeed i need to get these things out. So i was wondering if someone has seen a program/trick to get these out without having to kill a whole day doing it by hand.

Thanks again
Al

Alex,

If you are seeing the line breaks as a specific character you should be able to copy that within excel then do a find and replace with nothing in the "Replace" line. As for the HTML, you will need to remove that separately unless you can find an HTML/Text parser.

Are you seeing an issue with your descriptions or do you simply need to have plain text for your data feed? There is an issue within Excel where special characters will appear as line break symbols (rectangles), when they are really not, which will cause a large formatting issue within the file itself. In this cause you will have to go through the file and individually remove each of these characters.

I hope that this helps.

Thanks,

Toni Phillips