I am trying to paste text from a Word document to an Excel spreadsheet.
When there are 'enters' after lines of text, old term is carriage returns,
it causes the text to jump down to another cell for each 'enter' or new line
encountered in the text. I want all the text pasted to the destination cell,
not scattered throughout multiple contiguous vertical cells.
Does anyone know a setting or parameter in Excel to prevent the advancing of
cells for every 'enter' or line change in the text. My other option is to
reformat one at a time all the answers in the word doc, which is in some
cases multi line reponses to a 30 question survey.
Thanks..............Larry