|
Paste from Word Tables, ignoring Paragraph marks
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 |
Paste from Word Tables, ignoring Paragraph marks
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 |
Paste from Word Tables, ignoring Paragraph marks
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 |
| All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com