Bring in Word table

[Guest]

I am using Office XP and need to bring a Word table into Excel. I have no
problem copying and pasting the table, but if a Word cell contains multiple
lines, every line in the Excel sheet has it's own cell. Is there a way to
tell Excel to keep all text that is in a single Word cell in a single Excel
cell? Thanks!

 

[Guest]

Seems to me there must be some kind of paragraph return or line break in the
Word table. Turn your show/hide button on to see what the characters are,
then replace them all with spaces using Find/Replace. Let me know if you need
more help with that. Here's how to turn on the show/hide button:
http://www.officearticles.com/word/show-hide_button_in_microsoft_word.htm

 

[Dave Peterson]

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j (hit and hold the control key and hit j)
replace all.

You may have to use Format|cells|Alignment tab|check wrap text

Don't forget to close the word document without saving (or hit undo as many
times as necessary).