Paste from Word

[Guest]

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

 

[Guest]

Instead of paste, try special paste- paste text.

 

[Guest]

Did not work.

Instead of paste, try special paste- paste text.

 

[Dave Peterson]

If you're copying everything to a single cell in excel, just paste into the
formula bar. (A variation of Southpaw's suggestion.)

If you're copying from an MSWord table with each of those cells having multiple
paragraphs/linebreaks...

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j
replace all.

You may have to use Format|cells|Alignment tab|check wrap text

Don't forget to close the word document without saving (or hit undo as many
times as necessary).

 

[Guest]

Thanks.

If you're copying everything to a single cell in excel, just paste into the
formula bar. (A variation of Southpaw's suggestion.)

If you're copying from an MSWord table with each of those cells having multiple
paragraphs/linebreaks...

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j
replace all.

You may have to use Format|cells|Alignment tab|check wrap text

Don't forget to close the word document without saving (or hit undo as many
times as necessary).