Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Word address label file to an Excel spreadsheet
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. -- Thank You, Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Word address label file to an Excel spreadsheet
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 -- If this helps, please click the Yes button Cheers, Shane Devenshire "Andy" wrote: 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. -- Thank You, Andy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Word address label file to an Excel spreadsheet
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. -- Thanks, Andy "Shane Devenshire" wrote: 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 -- If this helps, please click the Yes button Cheers, Shane Devenshire "Andy" wrote: 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. -- Thank You, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert email address file in Excel 2000 to Word file with commas | Excel Discussion (Misc queries) | |||
How to convert an address file from Word into Excel? | Excel Worksheet Functions | |||
Convert address label layout to csv format | Excel Discussion (Misc queries) | |||
How do I make an address label in excel, then merge it with Word. | Excel Discussion (Misc queries) | |||
Convert Word Label to Excel | Excel Discussion (Misc queries) |