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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks