want to extract certain numbers from string

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, P...