| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
