Counting characters in a cell

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 ?
 
R

Rob

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)
 
H

Harlan Grove

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 365 overriding formatting choices 0
Count Number of Unique Cells That Don't Have Certain Characters 0
How to count the numbers in a Word document? 0
WORD VBA Search and switch to advanced ... 1
Multiple templates with common styles 2
Replace data to right of string problem 6
Is there a function to count how many times a cells value is used? 0
Adding the total # of characters in multiple cells 3

Top