Count a word(text) in a range of cell

[akarazzak]

[TABLE="width: 500"]
<tbody>[TR]
[TD]ACI's mission is to achieve business excellence through quality by understanding, accepting, meeting and exceeding customer expectations. ACI follows International Standards on Quality Management System to ensure consistent quality of products and services to achieve customer satisfaction. ACI also meets all national regulatory requirements relating to its current businesses and ensures that current Good Manufacturing Practices (cGMP) as recommended by World Health Organization is followed properly. ACI has been accepted as a Founding Member of the Community of Global Growth Companies by the World Economic Forum which is the most prestigious business networking organization. [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Count the word "ACI" appear in the above text using the appropriate formula[/TD]
[/TR]
</tbody>[/TABLE]

 

[lazermx]

Asuming your text is in cell A1 in cell B1 type ACI (uppercase) and in cell C1 enter the following formula:

=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,")))/LEN(B1)

Note: It's case senstive.

Cheers
Lazermx

 

[akarazzak]

Asuming your text is in cell A1 in cell B1 type ACI (uppercase) and in cell C1 enter the following formula:

=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,")))/LEN(B1)

Note: It's case senstive.

Cheers
Lazermx

Amazing
Thanks.