problem pasting Word table into Excel

[md95065]

I have a Word table which contains 3 columns and several hundred rows which I want to paste into an Excel spreadsheet.

The problem is that middle column of the table contains several lines of text, including line breaks, per row of the table.

When I paste the table into Excel, each line of text ends up in a separate Excel row even though they were all contained within a single table cell in the Word document.

There seems to be no easy way to fix this problem in Excel and I am wondering if I have to edit the Word document to remove all of the line breaks, do the copy and paste into Excel and then go and put all of the line breaks back in by hand to preserve the formatting that I want.

Help!!

I am an experienced programmer (25 years) but an Excel novice and I can't believe that something this simple and obvious could be so difficult so I assume that I must be missing something ...

Thanks in advance for any suggestions,

Michael

[oldchippy]

Hello Michael,

Welcome to the forum, does this link offer any help?

http://office.microsoft.com/en-us/he...994191033.aspx

[md95065]

Thanks for the suggestion, but that is exactly what I already did.

Suppose that I have a Word table that has three columns and one of the rows looks like this:

Please Login or Register  to view this content.

Note that this is a *single* row, but the middle cell contains 3 lines of text with line-breaks.

If I copy and paste this row into Excel, it takes up *three* rows and the text is split up into *three* cells, one line per cell. Since this is all related information I want everything to be on the same row, with the text in a single cell.

Unfortunately the only way that I have been able to make this work is to first edit the Word table to remove all of the line breaks from the text, copy and paste into Excel and then put all of the line breaks back in by hand.

Michael

PS I tried this with both Office 2003 and 2007 with exactly the same results.

[Bryan Hessey]

Thanks for the suggestion, but that is exactly what I already did.

Suppose that I have a Word table that has three columns and one of the rows looks like this:

Please Login or Register  to view this content.

Note that this is a *single* row, but the middle cell contains 3 lines of text with line-breaks.

If I copy and paste this row into Excel, it takes up *three* rows and the text is split up into *three* cells, one line per cell. Since this is all related information I want everything to be on the same row, with the text in a single cell.

Unfortunately the only way that I have been able to make this work is to first edit the Word table to remove all of the line breaks from the text, copy and paste into Excel and then put all of the line breaks back in by hand.

Michael

PS I tried this with both Office 2003 and 2007 with exactly the same results.

Hi,

Just a thought, if that works for you, then you could replace the line breaks with (say) #$# and then in Excel replace #$# with the line break, this could be as a shortcut triggered macro.

The required line would be

Please Login or Register  to view this content.

etc.
---