Word into Excel

[MJ]

I am trying to copy a table from Word into Excel. Copies
fine, goes in to a bunch of cells. THAT'S THE PROBLEM!!
I want my one big cell (with multiple hard returns within
a cell) to go into ONE cell in Excel. When copied, each
line in the one cell in Word goes in to its own cell in
Excel. How can I merge them together? PLEASE help?!
Thanks.
MJ

 

[Peo Sjoblom]

If it is one cell only, copy it, select the cell in excel and paste it into
the formula bar
instead of the cell, then press enter

 

[mj]

OHMYGOSH!!!! Thank you so much!!!! It is a little
tedious but it just might work!!! Thanks!

 

[Dave Peterson]

And if you want to get all the table at once:

Inside Word, select the table and do two Edit|Replaces.
First one replaces paragraph mark (^p) with a unique string ($$$)
second one replaces manual line break (^l) (lowercase ELL) with $$$

Then copy the table and paste into Excel.

then do an Edit|Replace within excel.
Replace $$$
with hit and hold the alt-key and type 0010 from the number pad
(It may look like nothing was entered, but try it.)

alt-0010 is the same as the alt-enter to wrap to a new line in an excel cell.

Don't forget to close the word document without saving.

 

[carolyn]

Thanks dave for your very clear answer to this query. You have saved m
no end of time!

When you say replace with 'hit' what do you mean?

your response was:

'then do an Edit|Replace within excel.
Replace $$$ with hit and hold the alt-key and type 0010 from the numbe
pad
(It may look like nothing was entered, but try it.)'

Thanks
Caroly

 

[Debra Dalgleish]

In Excel, choose Edit>Replace
In the Replace box, type the characters that you used in Word, e.g. $$$
Click in the With box
Hold the Alt key, and (on the number keypad), type 0010

This represents a line break in Excel. You won't see anything in the
'With' box, but click the Replace All button, and each instance of $$$
will be replaced by a line break.