View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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...