Welcome to the Community Forum where you can ask questions and share information with other members in the Connected Business Community. Please note that this is not technical support. If you have a matter for technical support, please visit my.connectedbusiness.com

Our old system stores customer street addresses in 3 separate fields in the DB. I have concatenated these together to account for the single address field in CB, using Char(10) to provide the line breaks as needed. The single address field looks fine in excel, but formats as a single "run-on" line in CB on import.

In Excel, if you have multiple source address lines (in this example 5) use this formula to concatenate in to one cell for import in to CB. It is based on row 2 in a spreadsheet and assumes the first line of address (cell A2) is populated. B2, C2, D2 and E2 contain the other address lines and F2 contains this formula; (copy column F and paste as text in to spreadsheet used for importing)