import into excel

[ReTeMa]

ola,

i have flat txt file (a telephone book):

zip: 12345
zip name: london
john doe
my street 12
tel: 12345678

zip: 45678
zip name: los angeles 
mary brown
avenue 321
tel: 87654321

etc. etc.

how can i import into excel and get each data in one row and more columns:

12345 | london |      john |   doe | my street |  12 | 12345678
45678 | los angeles | mary | brown |    avenue | 321 | 87654321
etc. etc.

tia

 

[DPlank]

I'm thinking you may need a VBA macro to parse the file and fill in the sheet manually. You don't have a format like CSV you can impost there.

[Waiting to be proved wrong, as usual...)

Cheers,
Dave

Probably the only Test Analyst on Tek-Tips

animadverto vos in Abyssus!

Take a look at Forum1393 & sign up if you'd like