Hi, I use a connection to Microsoft Business Contact Manager 2010 to import my contacts into an Excel table. al-pc_MSSMLBIZ MSSmallBusiness ContactExportView

The address can varey from 1 to 4 lines.
The City and Post Code are in seporate cells, which is ok.

My problem is that the first part of the the address is contained in one cell, but is displayed on separate lines within that one cell.

Displayed like this. Oak viewBroughall FarmBroughall

Displays like this in the formula bar when extended downwards

Oak view
Broughall Farm
Broughall

After I refresh the table I copy new entries onto another worksheet which is very similar and manually seporate the address lines into individual cells. I would like to automate this part of the process if possible.

Oak view Broughall Farm Broughall

I have tried using commas etc in Business Contact Manager, and then using Left, Mid and Right formulas with no luck.
Any help suggestion greatly appreciated.