Try this:

For a value in A2
And B1: A
And C1: B

B2: =LEN(A2)-LEN(SUBSTITUTE(UPPER(A2),B$1,""))
C2: =LEN(A2)-LEN(SUBSTITUTE(UPPER(A2),C$1,""))

Those formulas return the counts of "A" and "B" in cell A2,
respectively.

Is that something you can work with?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=527651