Excel splits Word table into multiple cells on paste

[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

 

[Guest]

Save the word table as a CSV then import it into Excel

Reg

 

[Phil]

Thanks, but I don't appear to have that option, I'm using office 2000 by the
way

 

[Dave Peterson]

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.

 

[Phil]

Will try that, thanks Dave

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.