Importing Word doc into Excel

[Guest]

I received a Word Doc with names and address of clients. I have to export
them into Excel but they are showing into rows and I would like them to
appear into columns. Ex. Name, Address, City, State, Phone #

It is appearing this way:
Mr. James Smith
123 Main St
Main, FL 55555
Tel: (727) 555-1212

How can I make this change without doing it one by one?

 

[wjohnson]

In WORD - Make sure there is a paragraph return after each item.
Then go to the MENU BAR and select TABLE - CONVERT - TEXT TO TABLE
Then in the popup menu - in the NUMBER OF COLUMNS enter 4 and then
click OK and now you can copy and paste into EXCEL.

 

[CaptainQuattro]

This works great.

If you find out that some lines end with manual line breaks instead of
paragraph characters, use the search and replace function to convert
the line breaks to paragraphs.

 

[Art Farrell]

Hi,

Another way if you have the list in an Excel sheet already.Assuming it
starts in A1 put the following in B1 and drag across to E1 and then drag
down:

=INDIRECT("A"&(4*(ROW()-1)+COLUMN(A1)))

Courtesy of an old post be Alan Beban.

CHORDially,
Art Farrell

 

[wjohnson]

You will also need to make sure that you do not have an extra paragraph
mark or manual line break between the rows - or stuff will not line
up.
To remove extra paragraph returns do the following in the find: ^p^p
and replace with a ^p.
This will find 2 paragraph returns and replace with 1.
You might have to run the find and replace a couple of times until you
get a "NOT FOUND" popup message.
The ^p is a lower case "p" and the ^ is Shift then hit the "6" key.
More info can be found in the find and replace box - select the "MORE"
and then "SPECIAL".