Word into Excel

  • Thread starter Thread starter MJ
  • Start date Start date
M

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
 
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
 
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.
 
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
 
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.
 
Back
Top