One way:

=COUNTIF(A1:A100,"*BJ3*")

In article ,
525047 wrote:

I have a large XLS which has columns containing multiple text initials
of people separated by commas and spaces within each column such as
below. I need to be able to count the number of occurrences of each
initial within a column into separate cells at the base of that column.
Any bright ideas?

COLUMN A
IN1, BJ2, BJ3
IN1,BJ3
BJ2 BJ3
BJ2

COUNTS
IN1=xxx
BJ2=xxx
BJ3=xxx