Counting duplicate numbers in a string

[abbccc]

i want Counting duplicate numbers in a string
for example Counting 2

22241278-------- Count(2)=4

[martindwilson]

=len(a1)-len(substitute(a1,2,""))

[abbccc]

no no no
i want Counting duplicate numbers in a string
for example Counting 2

222412788-------- Count(1)=1 & Count(2)=4 & Count(4)=1 & Count(7)=1 & Count(8)=2

[martindwilson]

yes yes yes
=len(a1)-len(substitute(a1,2,"")) gives 4 which is 4 lots of 2
=len(a1)-len(substitute(a1,8,"")) gives 2 which is 2 lots of 8
see attached for some examples

[abbccc]

this is for 0 , 1 , .... , 9
I want use for a string
for example

aaa22bb32 .............................................. Count(a)=3 & Count(2)=3 & Count(3)=1 & Count(b)=2
2 * 2 * 2 * 2 * 2 * 2 * 2 * 3 * 3 * 3 * 3............ etc

[martindwilson]

add a to z in the top row fill across
what do you want it to look like exactly
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic
another way is attached