View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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