Paste from Word
 

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

Paste from Word
 

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.

"Larry" wrote:

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

Paste from Word
 

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

"Southpaw" wrote:

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.

"Larry" wrote:

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