I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns.
I then have formulas concatenate across those rows and columns and add some HTML tags (
<tr>). Then I use the
CLEAN() function to wrap the result of those concatenations. I can then copy and paste from that final cell into MailChimp to send out an HTML email newsletter.
I'd prefer to convert the Excel file into a Google Spreadsheet since it keeps a revision history and allows live collaboration.
However, since there is no
CLEAN() function in Google Spreadsheets, if I copy from my Google Spreadsheet into HTML, there are lots of extra double-quotes that ruin everything.
Anyone know of a workaround?