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