Copying data from a table in Word 2010 to Excel 2010
Posted on 2013-11-05
I have a table in Word 2010 that contains fairly verbose data in certain cells. Some cells have multi-line data containing bulleted lists, newlines / paragraphs, and all sorts of formatting. Let us refer to these cells as "Complex Cells"
My GOAL: copy this data from this Word 2010 table to Excel 2010, and have EACH cell from the table in Word end up as a cell in Excel.
However, when I copy the table and paste it into Excel, the data from a single Complex Cells ends up in MULTIPLE fields in Excel. For instance, a bulleted list from a table cell ends up spread across multiple rows in Excel.
How do I copy the Complex Cell data from Word to Excel and retain the original cell structure?