Copy MS Word tables to MS Excel

When you copy table data from MS Word to MS Excel, line breaks in MS Word tables are replaced with new cells in MS Excel.

This can be quite annoying when you are copying and pasting large tables. A work-around is described below:

In the MS Word Table

1. Replace the string ”^p” with “#”.
2. Replace the string ”^l” with “#”.
3. After the above transformations are implemented, copy the MS Word table.

In MS Excel 

1. Paste the copied MS Word table in MS Excel. 
2. Replace the string “#” with [Ctrl + j], noting that [Ctrl + j] is actually a keyboard combination rather than plain text.