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?

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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=526152

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.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=526152

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".


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=526152