Copying and Pasting from Word 2007 to Excel 2007

[nyik]

I've got a lot of tables from a word doc (2007) that i want to paste into excel.

It's a very straight forward table that looks something like this (sorry for the poor formatting):

|------ |------ |------ |------ |
|Col1 |Col2 |Col3 |Col4 |
|------ |------ |------ |------ |
|text |text |text |text |
| |text |text |text |
|------ |------ |------ |------ |
|text |text |text |text |
| |text |text |text |
| |text |text |text |
| |text |text |text |
|------ |------ |------ |------ |

The problem is that I can't seem to paste inline paragraphs into ONE cell. The only way to do that is to double click into the excel cell and then paste. If I do a straight paste, it separates it into 1 cell per row of text. I don't want that. I want to keep it within the same cell.

I've also tried CSV, but for some reason excel's not recognizing the text qualifier that keeps the inline text in one piece.

HELP! I've spent a whole freaking day on this. Google hasn't turned up anything...

[mcplar]

SHould just double click in the cell so you see the cursor in the actual cell.. then paste

It's the only way to do it afaik.

[llau]

If you have paragraph mark in your WORD document then you may encounter this problem. This is because when Excel sees paragraph mark it will put them in different cells.

If you want to Excel interpret as ONE cell, then you need to replace all the paragraph marks to + (plus sign) in WORD before you copy and paste into Excel. Then you do the same trick. i.e. in Excel, replace + to paragraph mark.

To replace the paragraph mark to space in WORD, go "Find and Replace".
Then type ^p in "FInd What:".
And type + in "Replace with".

To replcae the plus sign to paragraph mark in EXCEL, go "Find and Replace".
Then type + in "Find what:"
And type CTRL+ENTER in "Replace with"
Give it a try.

Note: You may choose another character if there is a + in your document. The idea is to choose a character which is not in your Word document.
Hope this helps.