Address fields in columns...
 

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!!


nick

Please ignore - ipad playing up. Cant work out how to delete thread....