Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing text
I copied a paragraph from Word and used Paste Special to paste it to an Excel
document. I selected TEXT from the options in the Paste Special dialog box. Now I can see only part of the text, but when I hit F2 to edit it shows all of text. I have expanded my row to allow for the size of the paragraph. The only formatting I have done is to wrap text and merged cells to allow for the size of the test. I have also expanded my row to allow for the size of the text. Any thoughts as to why I see all the text when I hit F2, but only part of the text when viewing it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing text
You can place 32767 characters in a cell but Excel will display or print
only 1024 of these characters. You will see all of them in the formula bar. Add and Alt + Enter every 100 or so characters to increase that displayed limit. Don't bother merging any cells. That just makes a larger cell with the same limits as any single cell. Gord Dibben MS Excel MVP On Wed, 13 Jan 2010 08:12:01 -0800, ann wrote: I copied a paragraph from Word and used Paste Special to paste it to an Excel document. I selected TEXT from the options in the Paste Special dialog box. Now I can see only part of the text, but when I hit F2 to edit it shows all of text. I have expanded my row to allow for the size of the paragraph. The only formatting I have done is to wrap text and merged cells to allow for the size of the test. I have also expanded my row to allow for the size of the text. Any thoughts as to why I see all the text when I hit F2, but only part of the text when viewing it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text format and missing value. | Excel Discussion (Misc queries) | |||
Missing text in cells | Excel Discussion (Misc queries) | |||
missing text after printing | Excel Worksheet Functions | |||
Missing Text in a List Box | Excel Discussion (Misc queries) | |||
Missing text in a cell? | Excel Discussion (Misc queries) |