Paste from Word Tables, ignoring Paragraph marks

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?

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?
.

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

Thanks. I didn't know how to insert the Paragraph symbol in search/replace for Excel. This will do it.

"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

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