Export combines Address Line 1 and Address Line 2 into one cell in Excel

[DavidB4185]

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 

[William_A]

Hello @DavidB4185 (Andrea),

If you're using Excel, and potentially even Google Sheets, our higher level technical support team is recommending to use the Text To Columns feature in Excel. For the delimiter, enter CTRL-J. This should delimit by the Line Break character and split the data into two columns.