I sometimes have Word 2007 tables that I need to paste into Excel 2007.
Some of the cells have multiple lines (i.e., “paragraphs” in the Word sense). But when I paste into Excel, the multi-line cells are broken into multiple rows in the destination spreadsheet. What I’d like is for the full contents of each table cell to be pasted into a single cell in Excel, with Excel "new line" characters replacing the Word paragraph marks.
How can I copy a Word table to an Excel spreadsheet so that each cell in the original Word table corresponds to a single cell in Excel?