Alright, so Excel/Google Docs buffs, I need some help. I'm trying to upload some data onto a website - in particular a wiki. There's a spreadsheet that has all the data, so I've written some formulae that put it all into nice, easy to copy-paste cells which do everything like making the tables, inserting the relevant images, all that jazz nice and easily. I was pretty happy it was all lined up and ready to work perfectly, so I went to copy and paste the data in...
And for some reason, regardless of if I copy from Excel or Google Spreadsheets, the data gets extra quotation marks around each and every cell that I'm trying to paste. Which is a lot of them (in total it should come to around 1,000 or so, far too many to remove by hand). From a little looking online I gather it occurs due to having line breaks in the cells (kinda necessary for formatting). But I can't find a solution that works sensibly.
So the question: Does anyone know any way to stop automatically adding quote marks when pasting data that spans multiple lines in a single cell? Either an Excel or a docs solution is fine.