How do I perfom a character count in a single cell in Excel?

G

Guest

I need to peform a character count for certain cells in Excel. I found a
formula for counting words within a cell but not the number of specific
characters.
 
G

Guest

If you count spaces as a character, you can use directly the function LEN.
If you don't want the spaces to count, use something like:
=LEN(SUBSTITUTE(A1," ",""))

Hope this helps,
Miguel.
 

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

Top