Tuesday, 28 July 2009

Counting the number of characters

In the microsoft excel, you can count the number of characters (text or numbers), for example could see data table below
In column A is the set of characters, which will be selected and counted characters A, B, A1, A1B2, A2B1



To calculate the character, then create the following fomula:
In cell B6, type the formula:
= LEN (A6) - LEN (Substitute (A6, "A ",""))
in C6 cell type the formula:
= LEN (A6) - LEN (Substitute (A6, "B ",""))
in D6 cell type the formula:
= (LEN (A6) - LEN (Substitute (A6, "A1 ","")))/ 2
in E6 cell type the formula:
= (LEN (A6) - LEN (Substitute (A6, "A1B2 ","")))/ 4
in F6 cell type the formula:
= (LEN (A6) - LEN (Substitute (A6, "A2B1 ","")))/ 4



Related Posts by Categories



No comments:

Post a Comment

Random Posts