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.

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.