Excel splits Word table into multiple cells on paste

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I have extracted data from multiple word forms into a word table. When I
paste this data into excel it splits paragraphs into seperate cells forcing
other cells within the row to merge (i.e. four columns,a1:d1, within word
row one cell, b1, has 4 paragraphs, on pasting into excel the text in column
b is split into four cells within a column (b1 to b4).

Using paste special >> values the text is split into four cells within a row
(b1 to e1)

Does anyone have a macro that can detect and remove the paragraphs either
from the word table or from the excel worksheet?

Thanks in advance,

Phil
 
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.
 
Will try that, thanks Dave
Dave Peterson said:
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.
Click to expand...
 
Back
Top