Paste from Word

[Guest]

I am trying to Paste text from Word to Excel cells on a large spreadsheet
When there are multiple lines of text, separated by 'enters' or 'carriage
returns' it causes the Paste operation to put each line of text to a new
contiguous cell location in the spreadsheet starting with the target cell and
jumping down vertically.
Is there a setting or parameter in Excel which can turn off this jumping
cells feature so I don't have to reformat the responses to 30 survey
questions in a Word doc by removing all the enters(carriage returns)
Thanks..............Larry

 

[Guest]

Before pasting from Word, double click in the destination cell in Excel, then
paste. This will put all the text in one cell, with the manual line breaks
intact.

 

[Guest]

Works great.......thank you very much..........Larry