View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Miguel Zapico Miguel Zapico is offline
external usenet poster
 
Posts: 95
Default How do I perfom a character count in a single cell in Excel?

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.

"RonNette72791" wrote:

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.