Hello,

I want to use mail merge to send out a mail shot. When I export my contacts
I get a .CSV file with the entire address in a single column. Obviously, this
doesn't work because I want the address correctly laid out. i.e.;

Street,
City,
Area,
Code

Not;

Street, City, Area, Code

Is there any clever way that I can get Excel to split the lines of the
address into separate columns?

Note the commas that denote where the splits should occur.

Thanks

Graham.

Don't worry! I found it. Data -- Text to Columns...

Sorry, should have look harder before posting. :)

Thanks.

"Chuda" wrote:

Hello,

I want to use mail merge to send out a mail shot. When I export my contacts
I get a .CSV file with the entire address in a single column. Obviously, this
doesn't work because I want the address correctly laid out. i.e.;

Street,
City,
Area,
Code

Not;

Street, City, Area, Code

Is there any clever way that I can get Excel to split the lines of the
address into separate columns?

Note the commas that denote where the splits should occur.

Thanks

Graham.