want to extract certain numbers from string

[vedantaher]

i have an excel column like following and want to extract FREQUENCY OF every number e.g- frequency of PU-6 = 5 like that. thanks in advance

PU-6, PU-7, PU-7, PU-7

PU-6

PU-6, PU-6

PU-6, PU-7, PU-7, PU-7

[#2]

@vedantaher 

For example:

The formula in B8 is

=SUM((LEN($A$1:$A$4)-LEN(SUBSTITUTE($A$1:$A$4,A8,""))))/LEN(A8)

[#3]

thanks