Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
Hi Guys!
I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
Unfortunately, until the new Excel comes out, the 'visible' limit in a cell
is 1024 characters. The new Excel will, reportedly, show a million characters. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Shelley APG" wrote: Hi Guys! I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
If you add alt-enters to force a new line within the cell every 80-100
characters, you can see way more than the documented 1000 characters. Shelley APG wrote: Hi Guys! I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
Thank You So much for your responses!
I can not tell you how much time I waisted on that one! Hope to see the new excel version soon! "Dave Peterson" wrote: If you add alt-enters to force a new line within the cell every 80-100 characters, you can see way more than the documented 1000 characters. Shelley APG wrote: Hi Guys! I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
Ok, one more quick question.... will this effect saving as a CSV file and
importing it into a different program? Will all text go through regardless of what is visible? Thank You!!!! "Shelley APG" wrote: Hi Guys! I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Complete text in cell not showing
I would try it and see how that other program imports it.
Shelley APG wrote: Ok, one more quick question.... will this effect saving as a CSV file and importing it into a different program? Will all text go through regardless of what is visible? Thank You!!!! "Shelley APG" wrote: Hi Guys! I have exported information into excel and for some reason when looking at the worksheet some of the text is not showing in the larger text cells as complete. When I click on the cell the text appears in whole but looking at the worksheet it cuts off. I have used format, wrap text. I have adjusted all columns, I have tried AutoFit and still nothing. Any suggestions would be greatly appreciated!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
I have text in an Excel Cell that isn't showing all of it? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Text in cell not showing in full | Excel Discussion (Misc queries) |