How can I merge a WORD list into broken down colummbs on excel

C

Chris California

I have a list of information in word like this:

Name Phone addr.
chris 321321654 5
clancy way


Can I merge this 500 name list into excel automatically from word?
 
K

Kanga

Hi,

Try a copy paste. Then select your range of data (probably all stored in the
first excel column); go to data and choose text to column. Choose fixed width
and draw where the columns should be delimited.

Kanga
 
Top