Wrapping Text in Merged Cells

[brigla5]

I have a situation where text is being copied in Word and then pasted into an
Excel workbook. I have merged the cells and selected wrap text for the
particular cells being used for this. However, when the text is pasted into
the cell, sometimes the text doesn't wrap and parts of words get cut off or
it appears that the text wrap stops at a certain point and runs off to the
right. Is there something I'm doing wrong or is there a fix to this problem.
I know that merged cells do not autofit and dragging the cell to increase
the row height doesn't seem to fix the problem with the text which runs off
to the right. Any help would be greatly appreciated.

 

[Archimedes' Lever]

I have a situation where text is being copied in Word and then pasted into an
Excel workbook. I have merged the cells and selected wrap text for the
particular cells being used for this. However, when the text is pasted into
the cell, sometimes the text doesn't wrap and parts of words get cut off or
it appears that the text wrap stops at a certain point and runs off to the
right. Is there something I'm doing wrong or is there a fix to this problem.
I know that merged cells do not autofit and dragging the cell to increase
the row height doesn't seem to fix the problem with the text which runs off
to the right. Any help would be greatly appreciated.

Instead of placing the cursor in the cell, and performing a simple
copy, you should go to the cell, then highlight the cell contents up in
the formula bar, and select copy or Ctrl-c. Immediately hit Esc after
getting that copy into the clipboard cache, then enter the target cell,
with it already formatted and select paste or Ctrl-v. If there are
differences, the column width can have an effect, as can the placement of
the text within the cell (bottom center top, etc).

You can also right click when pasting, and select Paste special, and
select values, so no formatting carries over, and the target cell's
formatting remains intact.

 

[Sean Timmons]

Sounds like you are pasting into the cell. Try pastign into the formula bar
up top.

 

[Bob Bridges]

I've just done a little testing on this: I formatted some cells in Excel to
wrap text, and then used cut-and-paste to copy a paragraph from a Word
document. Here's what I've found:

a) When I simply paste the text into Excel, the target cell formatting is
changed to the Word font, etc, and wrapping is turned off; the text extends
out to the right of the cell (because in my test case there's nothing in the
cell to the right).

b) When I use PasteSpecial, interestingly enough I get the Word version of
PasteSpecial instead of the Excel version; I select Text, which I suppose is
equivalent to Excel's Paste Values, and what's displayed is the text in the
font of the target cell's previous default. Line wrapping is still on for
this cell, but the row height is unchanged so I see just the leftmost two or
three words, until I autofit the row height. After that, of course, the
wrapping is correctly displayed.

c) When I hit <F2> and paste the text into the formula bar using <Ctl-V> or
<Ctl-Ins>, the text is pasted into the formula bar without font formatting
and when I hit <Enter> the cell is still set to Wrap Text and the row height
is adjusted automatically.

Any of that help?

 

[The Last Mimsy]

I've just done a little testing on this: I formatted some cells in Excel to
wrap text, and then used cut-and-paste to copy a paragraph from a Word
document. Here's what I've found:

a) When I simply paste the text into Excel, the target cell formatting is
changed to the Word font, etc, and wrapping is turned off; the text extends
out to the right of the cell (because in my test case there's nothing in the
cell to the right).

b) When I use PasteSpecial, interestingly enough I get the Word version of
PasteSpecial instead of the Excel version; I select Text, which I suppose is
equivalent to Excel's Paste Values, and what's displayed is the text in the
font of the target cell's previous default. Line wrapping is still on for
this cell, but the row height is unchanged so I see just the leftmost two or
three words, until I autofit the row height. After that, of course, the
wrapping is correctly displayed.

c) When I hit <F2> and paste the text into the formula bar using <Ctl-V> or
<Ctl-Ins>, the text is pasted into the formula bar without font formatting
and when I hit <Enter> the cell is still set to Wrap Text and the row height
is adjusted automatically.

Any of that help?

Try from notepad with its word wrap turned on and sized as desired
(width).

Expand your research, dude!