How do you count number of characters in a single cell

J

JE McGimpsey

one way:

=LEN(A1)

which includes space characters, or

=LEN(SUBSTITUTE(A1," ",""))

which doesn't.
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
How to count the numbers in a Word document? 0
Counting the number of times a character occurs in a cell 1
Section and Page numbering 0
Possible to Combine reports to's to a single box? 0
WORD VBA Search and switch to advanced ... 1
Counting one Character as a String 1
Counting the Number of times the Slides are visited 0

Top