ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I merge a WORD list into broken down colummbs on excel (https://www.excelbanter.com/excel-discussion-misc-queries/34961-how-can-i-merge-word-list-into-broken-down-colummbs-excel.html)

Chris California

How can I merge a WORD list into broken down colummbs on excel
 
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?

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

"Chris California" wrote:

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?



All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com