I think you'll need a separate calc for each character or string you are searching for.
If you want a final accounting of all the separate strings, you can bale one last calc to concatenate the results together.
(Or maybe I'm misunderstanding what you are looking to do.)
1 of 1 people found this helpful
Do you mean like this?
This can be achieved like below ( Note turn Count to dimension)
Please mark the answer as HELPFUL/CORRECT if it really helps you
COPY HERE --->(LEN([Customer Name])-LEN(REPLACE([Customer Name],'B',"")))/LEN('B')
(LEN([Customer Name])-LEN(REPLACE([Customer Name],'A',"")))/LEN('A')