On Mon, 3 Nov 2008 07:07:01 -0800, bashtherat
wrote:

I used the following formula to count the number of times "NPRP served"
appears in a worksheet column: =COUNTIF(H3:H38,"*NPRP served*"); but it stops
counting if there is too much text before the target text appears.

Why does this happen and how do I get round it?

Please help.


Shouldn't happen, unless you're running into a limit on the number of
characters in the cell, in which case the value wouldn't be there.

Please give example of an instance how this fails.
--ron