Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Karen
 
Posts: n/a
Default Is there a limit to the size of a cell containing text in Excel 20

I have a cell that contains a large quantity of text. It wraps correctly for
most of the cell, but then stops wrapping the text correctly after approx
1000 characters. This happens in more than one cell in the worksheet. As an
experiment I copied and pasted the cell into Word. The text is complete and
wrapped correctly in a word table cell.

I have suggested my client in the interim copy and paste the text into Word,
but they would prefer to just use Excel. Is this a limitation of Excel? Or
is this something I can fix.
  #2   Report Post  
Paul B
 
Posts: n/a
Default

Karen, from help the limit in excel is, cell content 32,767 characters. Only
1,024 display in a cell; all 32,767 display in the formula bar. for more
information see Excel specifications and limits in help.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Karen" wrote in message
...
I have a cell that contains a large quantity of text. It wraps correctly

for
most of the cell, but then stops wrapping the text correctly after approx
1000 characters. This happens in more than one cell in the worksheet. As

an
experiment I copied and pasted the cell into Word. The text is complete

and
wrapped correctly in a word table cell.

I have suggested my client in the interim copy and paste the text into

Word,
but they would prefer to just use Excel. Is this a limitation of Excel?

Or
is this something I can fix.



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you add a few alt-enters (to force a new line within the cell) every 80-100
characters, you'll be able to see lots more than the documented 1024 characters.



Karen wrote:

I have a cell that contains a large quantity of text. It wraps correctly for
most of the cell, but then stops wrapping the text correctly after approx
1000 characters. This happens in more than one cell in the worksheet. As an
experiment I copied and pasted the cell into Word. The text is complete and
wrapped correctly in a word table cell.

I have suggested my client in the interim copy and paste the text into Word,
but they would prefer to just use Excel. Is this a limitation of Excel? Or
is this something I can fix.


--

Dave Peterson
Reply
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
Character limit per cell BrianR Excel Discussion (Misc queries) 3 May 19th 05 04:50 PM
a way to limit the characters allowed in a cell? EmRit24 Excel Worksheet Functions 3 April 29th 05 09:30 PM
Can I limit a cell to 72 characters? How? Chris Excel Discussion (Misc queries) 2 December 28th 04 05:57 PM
limit worksheet view to specified cell range Mike Setting up and Configuration of Excel 2 December 17th 04 12:13 AM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 04:03 PM


All times are GMT +1. The time now is 04:48 PM.

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

About Us

"It's about Microsoft Excel"