How can I find the frequency of certain text characters in excel?

Question

I have tried 'search' and 'find' functions without luck. Is there any way to count how many times the letter 'e' or a combination of 'tl' occurs in individual cells or in a whole text string?

Answer 1

There are two ways to accomplish:



1) Use the FIND function in a formula. However, it can only check one cell at a time. here's how:



FIND (find_text, within_text, start_num)



Find_text is the text you want to find.



Within_text is the text containing the text you want to find.



Start_num specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1.







2) Use the replace function (Not in formula). This will give you total occurences when finished replacing. However, it doesn't tell you what cells they were in! Here's how:



Click EDIT, choose REPLACE, fill in "Find What" and "Replace with" then click "Replace All". After its finished Excel will tell you how many it replaced. Then click undo button to reverse the changes.







I hope these prove helpful to you.

Regards,

QwertyKPH @ Yahoo

Answer 2

A really easy way is to go Edit->Find and click on the find and replace tab. Put what you want to find in the find box and put the same thing in the replace box. Then click replace all. A dialogue box will pop up saying how many times it has replaced what you wanted, so that is how many times it appears.

Answer 3

You can use the count function and specify a range for excel to look for and return a value in a specified cell.

Answer 4

Use a User Defined Function to count characters in a text string.



http://answers.yahoo.com/question/;_ylt=AolTxMJpkiDpLDbUoY_vqTUjzKIX?qid=20060627191228AAQB2xh

Answer 5

If the basically quote is basically there to make the numbers a textual content cloth field, then you are able to easily format the cellular as a mode and then duplicate that format down. that stands out as the least puzzling. in case you want to coach a formulation you may also attempt this. =staggering(A1, LEN(A1)-a million) Then duplicate down