View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Wrap text is tempermental within a single cell

Hi,

So there are no Hard carriage returns in Word, nor simple carrage returns,
the text just flows?


I can't duplicate the problem. If I select a sentence in Word and copy it,
move to a merged cell in Excel which has Word Wrap on, and click the formula
bar and paste everything comes in just fine.

If I select multiple paragraphs in Word and do the same thing it comes in as
multiple paragraphs in the merged cell.


--
Thanks,
Shane Devenshire


"EvergreenHawk" wrote:

When I copy and paste into a merged cell (required by client to stay with
their format on an RFI), the text may wrap in some areas and not in others
within the same cell. I have tried a number of suggestions that I've seen,
including: pasting into the cell above the spreadsheet, adding additional
lines with Alt+Enter prior to pasting, "Paste Special', trying both formats
of general and text, confirming the text in word is all the same format prior
to pasting,

Any additional suggestions?