copying Word-Table to Excel

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

When copying a table (where a table item contains
formatted text with "line breaks") to Excel, each "line
break" generates a new sub-row and not, as wanted, an
equivalent "line break" in the corresponding excel cell
(which can be generated manually by pressing ALT+ENTER).

How can I reach this?
Is it, alternativly, possible to generate the ALT+ENTER in
Excel automaticly by using a special control caracter in
the "replace" field of the search&replace function?

Peter
 
If you change the table in Word to use a special character instead of a carriage return, then
when you get it into Excel you can replace that character with character number 10. To do that,
in the Replace with box, hold down the ALT key and on the numeric keypad type 0010.
 
Just to add to Myrna's reply:

That table in word can contain both the newline ^l and new paragraph ^p marks.
Each of these cause trouble in excel. So change both of them to that special
character. (I like to use $$$$$.)
 
Back
Top