If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. | Rachel King | General Discussion | 39 | August 21st, 2009 09:54 PM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
How do I have a cell in a word table be larger than 1 page? | Kevin | Tables | 1 | August 25th, 2004 08:43 PM |