One common way is to use Data | Text-to-Columns and specify some
character which deliminates the different fields, eg comma. It is not
clear from what you have posted if a comma separates each part of the
address, and it can be awkward anyway as different addresses have a
differing number of fields. If you post some more examples then we may
be able to suggest ways of extracting part of the address at least (eg
phone/fax numbers).

Hope this helps.

Pete