#1   Report Post  
Javster95
 
Posts: n/a
Default Capacity

What is the capacity of charactors in a cell?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

A cell can contains 32K characters, although only about 1K can be
displayed.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Javster95" wrote in
message
...
What is the capacity of charactors in a cell?



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

Just to add to Chip's reply...

If you sprinkle alt-enter (to force a new line within the cell) every 80 or 100
characters, you can see lots more than the documented 1024 characters.



Javster95 wrote:

What is the capacity of charactors in a cell?


--

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
Lookup Vector > Lookup Value Alec Kolundzic Excel Worksheet Functions 6 June 10th 05 02:14 PM
Counting capacity based on technician schedule Nadine Excel Worksheet Functions 1 June 5th 05 06:47 AM
Can I increase row capacity beyond 65536 rows Trish Excel Worksheet Functions 2 February 23rd 05 11:15 PM
Capacity Assessment NG Excel Discussion (Misc queries) 0 January 21st 05 10:41 PM


All times are GMT +1. The time now is 02:43 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"