Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Wrap text is tempermental within a single cell

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?


  #2   Report Post  
Posted to microsoft.public.excel.misc
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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Wrap text is tempermental within a single cell

These are multiple paragraphs. However, in different individual paragraphs,
some text wraps and some just keeps going on in a single line.

"ShaneDevenshire" wrote:

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get date/time to wrap (format - wrap text doesn't work)? Alex Excel Discussion (Misc queries) 3 April 4th 23 03:29 PM
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 03:07 PM
How do I view all text in a merged cell? Wrap text is activated. susjorg Excel Discussion (Misc queries) 1 January 23rd 07 08:34 PM
Why won't text in cell wrap. Cell format set to wrap. DRB Excel Discussion (Misc queries) 2 September 28th 06 09:27 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 08:13 PM


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"