exporting from outlook contacts

[guppie via OfficeKB.com]

when i export from contacts to excel my address lines appear in one column
except for the last one which maps to the city field which is fine. how do i
get each line in my street address to map to a seperate column?