try
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A",""))
or if b1 contains A
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),b1,""))

--
Don Guillett
SalesAid Software

"Pookie76" wrote in
message ...

Is it possible for me to have excel sum all the one letter codes into
individual cells and let me know the count?

Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
and have those sums placed in an individual cell for each?

Thanks for the help.


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