Counting number of time a character appears in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know a way to automatically count how many times a certain
character counts in a text string?
 
I meant to say:

Does anyone know a way to automatically count how many times a certain
character appears in a text string?

(i.e. "w" appears 3 times in the string above)
 
Henrik wrote...
Does anyone know a way to automatically count how many times a certain
character counts in a text string?
Click to expand...

To count the number of Xs in s, try

=LEN(s)-LEN(SUBSTITUTE(s,"X",""))
 
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

will count the occurrence of a in cell A1, if you have a range with strings
use

=SUMPRODUCT((LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a",""))))
 
FYI, I figured it out:

=LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,"character",""))
 
Does anyone know a way to automatically count how many times a certain
character counts in a text string?
Click to expand...

To count the number of appearances of a character in a text string:

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


--ron
 
You must log in or register to reply here.

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

Counting the number of times a character occurs in a cell 1
Counting Characters In A String 2
counting no. of times a character occurs in a cell 3
Count the times a specific character appears in a cell 3
Formula/Function for Counting Characters in a cell 4
Maximum characters in cell 2
count no. of commas (,) in a string in a cell 3
Adding the total # of characters in multiple cells 3

Back
Top