ExcelBanter - I a formula that outputs the number of occurances of a specific t.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I a formula that outputs the number of occurances of a specific t. (https://www.excelbanter.com/excel-discussion-misc-queries/14696-i-formula-outputs-number-occurances-specific-t.html)

Artem

I a formula that outputs the number of occurances of a specific t.

I am trying find out a number that a specific word appears in a single
worksheet, is there an excell function that can do that?

Harlan Grove

Artem wrote...
I am trying find out a number that a specific word appears in a single

worksheet, is there an excell function that can do that?

=SUMPRODUCT((LEN(A1:Z1000)-LEN(SUBSTITUTE(A1:Z1000,YourWord,"")))
/LEN(YourWord))

All times are GMT +1. The time now is 09:12 AM.