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 (<td>
, <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?
" <table cellpadding=""0"" cellspacing=""0"" border=""0"" width=""645"" class=""couponBoundary""> <tr> <td width=""130"" class=""couponStoreLogoCell""> <div align=""center""> <img src=""/images/merchants/756_t.jpg""> </div> </td> </tr> </table>"
clean()
orregexreplace()
, those newlines get weeded out, and no escaping is necessary. The smartest solution would be to modify the formulas that produce the newlines in the first place. See What is the XY problem?