How can I count the number of times a letter repeats in a string?

  • Thread starter Thread starter Guest
  • Start date Start date
Wiley,

If your string is in A1 and you are trying to count the occurences of
the letter "a" then:

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

HTH

Steve
 
Wiley,

If your string is in A1 and you are trying to count the occurences of
the letter "a" then:

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

HTH

Steve
 
See other post.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
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

Numbers of repeats of a string 11
letter number count 11
count number of letters in a string 3
Count letter string, e.g. h/EL/p 16
COUNT unique letter in a column 6
count how long it will takes for a number to repeat 1
COUNTING THE SAME VALUES IN A SHEET 3
Want to count all repeated number only once in Excel 2007. 2

Back
Top