Paste from Word Tables, ignoring Paragraph marks

[Guest]

I have sorted a Word document into a many-row 3-columntable and want to paste or import it into Excel. Many of the Word table cells have text with either paragraphs or soft carriage returns.

I would like to create one Excel cell for one Word table cell but, when I paste into Excel, a new row is created for every paragraph or soft CR. Is there any way to get Excel to ignore paragraph marks when pasting?

 

[jeff]

Hi,

Sorry, but I believe when Excel sees a CarriageReturn,
it takes it as an indicator for a new row. Unless you
can remove them in Word, I think you're stuck.

Anybody?

jeff

-----Original Message-----
I have sorted a Word document into a many-row 3-

columntable and want to paste or import it into Excel.
Many of the Word table cells have text with either
paragraphs or soft carriage returns.

I would like to create one Excel cell for one Word table

cell but, when I paste into Excel, a new row is created
for every paragraph or soft CR. Is there any way to get
Excel to ignore paragraph marks when pasting?

 

[Debra Dalgleish]

Dave Peterson posted the following instructions, that may help you:

http://groups.google.com/groups?&[email protected]

 

[guat]

Hi Debra, I know this question is 4 years old, and I wonder if you are still
around? I'm using your instructions in MS Word 2003, and the find and
replace function isn't finding any Manual Line Breaks or Paragraphs. What am
I doing wrong?
I sure have plenty of them in my document.

 

[Dave Peterson]

I'm not Debra, but I'd say try it again.

And if it doesn't work, share the exact details that you tried.

 

[guat]

Dave - you are a pro! I was using paragraph character rather than paragraph
mark on this list. This saved me hours of work!! Thank you!