Retain multi-line cells when pasting Word table into Excel
In Word, select the table.
Press Ctrl+H to activate the replace dialog.
Enter ^p in the Find what box.
Enter some text that doesn’t occur otherwise in the Replace with box, for example @@@@.
Click Replace All and don’t allow it to continue beyond the table.
Close the Replace dialog.
Copy / paste the table into Excel.
Press Ctrl+H to activate the replace dialog.
Enter @@@@ (or whatever you used in Word) in the Find what box.
Press Alt+0010 in the Replace with box.
Click Options >> and make sure that the “Match entire cell contents” check box is clear.
Click Replace All.
You may have to format the cells to wrap text.