Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel |