Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
String-in-Cell .... too long??? Word Wrap not working...PLEASE HE
I have a data extract taken from a Share Point list that has larger memo-type
data in it. I am trying to format some of this data in Excel for a report we are creating and can't get the raw-text-data to wrap correctly in the cell. The data has not been truncated, as all of it is in the cell...it simply won't wrap to the next line like it should, even with the "Wrap Text" formatting parameter activated. It looks as though the text string just continues into the next, right-most cell and isn't completely visable. Please advise... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
String-in-Cell .... too long??? Word Wrap not working...PLEASE HE
Hi,
the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Steve P" wrote: I have a data extract taken from a Share Point list that has larger memo-type data in it. I am trying to format some of this data in Excel for a report we are creating and can't get the raw-text-data to wrap correctly in the cell. The data has not been truncated, as all of it is in the cell...it simply won't wrap to the next line like it should, even with the "Wrap Text" formatting parameter activated. It looks as though the text string just continues into the next, right-most cell and isn't completely visable. Please advise... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
String-in-Cell .... too long??? Word Wrap not working...PLEAS
I have the same problem in Excel 2007 and the data in the cell is < 30
characters. I simply cannot get excel to wrap the text--and, yes, I have the "wrap text" box checked. The only thing I've found that enables me to see the bulk of the text is to increase the row height--which is unacceptable. "Shane Devenshire" wrote: Hi, the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Steve P" wrote: I have a data extract taken from a Share Point list that has larger memo-type data in it. I am trying to format some of this data in Excel for a report we are creating and can't get the raw-text-data to wrap correctly in the cell. The data has not been truncated, as all of it is in the cell...it simply won't wrap to the next line like it should, even with the "Wrap Text" formatting parameter activated. It looks as though the text string just continues into the next, right-most cell and isn't completely visable. Please advise... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
String-in-Cell .... too long??? Word Wrap not working...PLEAS
Have you tried setting the row to Autofit?
Wraptext means nothing if rowheight is manually set. Gord Dibben MS Excel MVP On Fri, 19 Feb 2010 11:29:02 -0800, CeeTee9 wrote: I have the same problem in Excel 2007 and the data in the cell is < 30 characters. I simply cannot get excel to wrap the text--and, yes, I have the "wrap text" box checked. The only thing I've found that enables me to see the bulk of the text is to increase the row height--which is unacceptable. "Shane Devenshire" wrote: Hi, the answer is version dependent: 2003: Cells can contain 1024 characters in a formula Cells can contain 32,767 text characters but only the first 1023 will be visible (unless you use Alt Enter to force line breaks) 2007: Cells can contain 8192 characters in formulas Cells can contain 32,767 text characters in cells and all can be seen and printed without needing to use Alt Enter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Steve P" wrote: I have a data extract taken from a Share Point list that has larger memo-type data in it. I am trying to format some of this data in Excel for a report we are creating and can't get the raw-text-data to wrap correctly in the cell. The data has not been truncated, as all of it is in the cell...it simply won't wrap to the next line like it should, even with the "Wrap Text" formatting parameter activated. It looks as though the text string just continues into the next, right-most cell and isn't completely visable. Please advise... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem w/word wrap opening up cell | Excel Discussion (Misc queries) | |||
Word Wrap Not Working | Excel Worksheet Functions | |||
Word Wrap not working correctly | Excel Worksheet Functions | |||
how do I get alt-enter to expand word wrap cell | Excel Discussion (Misc queries) | |||
word wrap not working | Excel Discussion (Misc queries) |