LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem w/word wrap opening up cell Meenie Excel Discussion (Misc queries) 2 January 21st 09 04:53 PM
Word Wrap Not Working Nick Wakeham Excel Worksheet Functions 0 January 15th 09 03:58 PM
Word Wrap not working correctly L. S. Martin Excel Worksheet Functions 0 January 23rd 06 03:23 PM
how do I get alt-enter to expand word wrap cell GREYL Excel Discussion (Misc queries) 5 November 14th 05 05:28 PM
word wrap not working bbxrider Excel Discussion (Misc queries) 2 December 8th 04 06:55 AM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"