Counting characters in a cell

  • Thread starter Thread starter lynn
  • Start date Start date
L

lynn

What formula do I use to count how many characters are in
a cell ? Also, I know a cell can only show 1024 or so
characters. Is there a way to get it to show more ?
 
There is no way to extend the number of characters
displayed in a cell, that I know of..

The formula reurning the number of characters in cell A1
is [and spaces count!]:
=LEN(A1)
 
What formula do I use to count how many characters are in
a cell ? Also, I know a cell can only show 1024 or so
characters. Is there a way to get it to show more ?
Click to expand...

If you add CHAR(10) characters (ASCII linefeeds, which are treated as nwelines),
you can display more than 10,000 characters provided you use a small typesize,
large column width and row height, and enable wordwrap.
 
Back
Top