I want to count number of times a string is appearing in a range of cells, for which I entered COUNTIF formula in an adjacent column i.e. Column C.

=COUNTIF($A$2:$A$929,B2)

The formula gives me perfect results untill the string length goes more than 255 characters.

So I wanted to know is there any way I can count number of times a string of more than 255 characters is appearing in a range of cells?