LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace paragraph marks in Excel Nanapat Excel Discussion (Misc queries) 1 July 18th 08 12:57 AM
how to hyperlink to a paragraph in a word file? ViestaWu Excel Discussion (Misc queries) 3 June 26th 08 01:01 PM
How do I set up a hyperlink to a word in a paragraph? Carlos Valdez Excel Discussion (Misc queries) 3 January 29th 08 10:00 PM
Formating, paragraph marks, boxes etc, how do I get rid of them? Josh Excel Discussion (Misc queries) 1 December 27th 04 08:33 PM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 09:53 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"