Convert a Word address label file to an Excel spreadsheet

A

Andy

I have a Word address file (Avery 5160) that I would like to convert to an
Excel spreadsheet that will put the names, address, city, state & zip into
rows & columns.
 
S

Shane Devenshire

Hi,

what does your data look like in Word? How do you want to lay it out in
Excel?

Of course you can select all the data in Word, choose Copy, move to Excel
and choose Edit, Paste
 
A

Andy

Hi Shane,

Thanks for your responce.
The word layout is 30 addresses to page. Three columns and ten rows. Each
address is complete, exactly as you would see if it were a mail piece
delivered to your home.
In Excel I would need to have the first address set up with the name in cell
"A1", address in cell "B1", City in cell "C1", State in cell "D1" and zip in
cell "E1". The second address would be set up the same in cell A2 through E2,
and so on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top