Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you transfer Labels in Word to Excel?
I am trying to figure out how to transfer labels from a Microsoft word into
Microsoft Excel so that they are in speadsheet form with the names in one column, the address in another column and the city , state and zip in seperate columns also. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you transfer Labels in Word to Excel?
Hi julzdolph21. The only way I've been able to do it is to copy all the
addresses into Column A. Then copy each address and Edit -Paste Special - Transpose into columns B, C, D, E. It helps if the addresses are consistent - three or four lines. You could record a macro to save time in the Edit - Paste Special - Transpose routine I found it helpful to insert a row at row 1 in the macro so that you're inserting the data into the same row everytime. Also, delete the address cells in column A each time so that you are always copying the same cells. HTH -- Sincerely, Michael Colvin "julzdolph21" wrote: I am trying to figure out how to transfer labels from a Microsoft word into Microsoft Excel so that they are in speadsheet form with the names in one column, the address in another column and the city , state and zip in seperate columns also. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel merge to create labels in word | Excel Discussion (Misc queries) | |||
Excel Data File to Word Labels | Excel Discussion (Misc queries) | |||
Word address labels to Excel Columns | Excel Discussion (Misc queries) | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
transfer of data from Excel to MS Word | Excel Discussion (Misc queries) |