Pasting to Excel from Word - stop a Word new line being converted into a new cell
- by Sean McRaghty
So I have a table in MS Word which has two columns. In the second column the text is spread on multiple lines, ie I have pressed 'Enter' to achieve this.
When I paste into Excel, it converts these separate lines into separate cells.
What I want it to do is to keep the lines in the same cell, just on different lines, ie what would happen if I were to press Alt+Enter in a cell in excel.
How would I go about this?