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


--
525047