How do you transfer Labels in Word to Excel?

[Guest]

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.

 

[Guest]

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