Retain multi-line cells when pasting Word table into Excel

 

https://answers.microsoft.com/en-us/office/forum/office_2007-excel/retain-multi-line-cells-when-pasting-word-table/c16c4831-a9c7-47b8-8d0d-94ef53c3cbdd?auth=1

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.

Back to Top