Windows 7 - Address fields in columns...

Asked By Nick_GB on 12-Aug-12 06:56 PM
Hi - one day i'll be able to help but alas my excel quest leads me to
learn rather than coach until that time comes, i need your help.

i have 10,000 names and address in a .txt form which i need to import
into excel, save as a .csv. The names are formatted as below:

Name :         fred blogs
address:       1 the street
addres 2:
address 3: Derby

plus the usual fac line etc...

(10000 times in column a1:b1)

how am i able to have the data under one heading and 10000 rows....?

your help would make me very happy!!