Rather than explain the process here, how about you send me the workbook?

I'll transpose it all for you and show you how I did it.

gorddibbATshawDOTca


Gord


On Sun, 10 Jan 2010 18:01:33 -0500, "Ilya Zeldes"
wrote:

Gord,

in this workbook (just one sheet), each row contains one entry. First
cell -Last Name, second cell - First Name, etc., each cell contains just one
item: street address, city, state, zip...

Ilya.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
How is the original data laid out?

All in one cell?

In one row but separate cells?

Is Last name, First name in one cell or two?

How about Street Address, City, Zip?

If you wish, send me a copy of the workbook.

gorddibbATshawDOTca change the obvious for ny email address.


Gord Dibben MS Excel MVP

On Sat, 9 Jan 2010 20:05:30 -0500, "Ilya Zeldes"
wrote:

I exported a few hundred contacts from my Windows Live Mail as CSV file
and
opened it in Excel 2002. Of course, I can easily print this spreadsheet as
it is, where each row contains all information about each entry. However,
I'd like to print this information in a form of an address book:

Last Name, First Name
email address
Street Address, City, Zip
Home Phone
Business phone

Last Name, First Name
email address
etc.

Is there a way to do so?