Originally Posted by Nick_GB

Hi Spencer

For su

Address details from the *.txt file are formated as follows

Name: Fred Blogs
Address1: The Street
Town: New Town
County: Sussex
PC: AB1 2CD
Telephone: 01234 567890
Fax: 01234 567899

Name: Jane Blogs
Address1: The Old Street
Town: Old Town
County: Sussex
PC: DC2 1BA
Telephone: 0987 654321
Fax: 0987 654322

10,000 more names...

All names are formated in this way. When I import the text using the wizard it sorts the heading from the text no probs. (I add the : into the criteria and it inserts the column.

WHat I would like to achieve is he follow
Name Address1 Town County Post Code Tele FAX
Fred Blogs The Street New Town Sussex AB1 2CD
Jan Blogs The Old Street Old Town Sussex DC2 1BA

hope this is enough to help