| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste from Word | Excel Discussion (Misc queries) | |||
| Paste from word to excel, into one cell. | Excel Discussion (Misc queries) | |||
| COPY & PASTE WORD Doc into EXCEL | Excel Discussion (Misc queries) | |||
| paste to word | Excel Discussion (Misc queries) | |||
| Paste from MS Word | Excel Worksheet Functions | |||
Linear Mode
