Splitting data?

[Ket]

Hello,

I am using Win2K and Office 2K. I have a spreadsheet, in which each
cell in column A contains names and addresses in the format:
Name
Address
Address2
Address 3
Town
County
Country

Therefore, each row in column A has the above information and each
line of data is separated with a soft return.

I would like to know how to split this data so that the name stays in
column A, Address is moved to A2, Address3 is moved to A3 and so on.

The end result will be a spreadsheet with name and address details
with each part of the address in a different cell on the corresponding
row.
I hope this makes sense and thanks for any help in advance.

Regards

Ket.