![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com