Hi - we regularly export our contact database to Excel to send our subscribers a printed copy of our magazine. However, lately the export combines Address Line 1 and Address Line into one Excel cell. Our distribution house won't deal with the data in this way. So we have to edit the spreadsheet to move the second line into another column. I've tried the Text to Column function in Excel, but this doesn't suit this data, because I don't think there is a delimiter on it? Is there anyway you could reinstate exporting the data into two cells? Or, can someone explain how to split the lines into two columns once in the Excel Spreadsheet? Much appreciated, Andrea
... View more