I'm having the same problem.
It seems that when addresses are input into Outlook Contacts, they cannot be
split up into AddressStreet1, AddressStreet2 and AddresssStreet3, but all end
up dumped in a single 'Street' box, separated by carriage returns, which is
then exported into Excel into a single cell, called AddressStreet1, including
those carriage returns. AddressStreets 2 and 3 remain empty, but are there!
Separating them out can be done by importing into Word replacing each
carriage return with a symbol and then then importing back into Excel and
splitting the text into columns using the symbol as the separation point.
It's a real pain, but is possible.
Is there a way of inputting the data into the 3 AddressStreet fields rather
than the catch all 'Street' box?
Thanks