Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve
 
Posts: n/a
Default Pasting Word table cell with paragraph markers into single Excel c

I have a Microsoft Word document that contains a table, each cell of which
may contain paragraph markers. I need to copy and paste this table into
Excel. However, whenever a cell from the Word table contains paragraph
markers, rather than pasting the contents of the entire cell into a single
cell in Excel, the paragraph markers are treated as delimiters, and the data
is pasted into multiple Excel cells. If the cell from the table in Word
contains one paragraph marker, then when I paste that cell to Excel, it
pastes it into two cells. If it contains two paragraph markers, then it
pastes into three cells, and so on. I need to be able to paste this Word
table into Excel so that the paragraph markers are treated like "alt-Return"
- that is, a hard return within a single cell in Excel, so each cell from the
table in Word gets pasted into one cell in Excel, regardless of how many
paragraph markers are contained in each cell. Any ideas?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default


Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: hit and hold the alt and type 0010 from the number pad--not above
QWERTY.

It may look like you haven't done anything, but if you did it right, you
replaced $$$$$ with alt-enter.
Replace all.

Don't forget to close the word document without saving (or hit undo as many
times as necessary).


Steve wrote:

I have a Microsoft Word document that contains a table, each cell of which
may contain paragraph markers. I need to copy and paste this table into
Excel. However, whenever a cell from the Word table contains paragraph
markers, rather than pasting the contents of the entire cell into a single
cell in Excel, the paragraph markers are treated as delimiters, and the data
is pasted into multiple Excel cells. If the cell from the table in Word
contains one paragraph marker, then when I paste that cell to Excel, it
pastes it into two cells. If it contains two paragraph markers, then it
pastes into three cells, and so on. I need to be able to paste this Word
table into Excel so that the paragraph markers are treated like "alt-Return"
- that is, a hard return within a single cell in Excel, so each cell from the
table in Word gets pasted into one cell in Excel, regardless of how many
paragraph markers are contained in each cell. Any ideas?


--

Dave Peterson
Reply
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
How can I use word wrap in a merged cell in excel 2000? PartnersHC Excel Discussion (Misc queries) 4 October 18th 09 10:02 PM
Can not see all of a pasted paragraph from Word in a cell. Kat Excel Discussion (Misc queries) 2 December 23rd 04 07:37 PM
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 05:43 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
How to convert the table in word to excel sheet? Santhosh Excel Discussion (Misc queries) 1 December 2nd 04 11:15 AM


All times are GMT +1. The time now is 03:24 PM.

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

About Us

"It's about Microsoft Excel"