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.


"Debra Dalgleish" wrote:

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

http://groups.google.com/groups?&thr...4761%40msn.com

Joe G wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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 wrote:

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.

"Debra Dalgleish" wrote:

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

http://groups.google.com/groups?&thr...4761%40msn.com

Joe G wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



--

Dave Peterson

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!

"Dave Peterson" wrote:

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 wrote:

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.

"Debra Dalgleish" wrote:

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

http://groups.google.com/groups?&thr...4761%40msn.com

Joe G wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



--

Dave Peterson