Need help counting single integers within a text string

Hi,

I need some help with finding a way of counting single integer entries within a text string.
The data is auto generated by a third party software.

There are 28 possible integers within each "results" cell.

I would like to be able to count how many times of a specific integer appears within the whole column.
For example: How many times does "42" appear in column AJ (Results)? Sample.xlsx

Is there a function that can do this? I know the COUNTIF does not help due to the multiple integers per cell.

If no function exists, is it possible for a function to separate the integers within each text string into their own cells, which would then allow for a countif function to be used.

Please see the attached sample of the data set.

Thank you for any and all assistance in this matter.

Hi sktneer,

Thanks for the response.
That doesn't really help.
I need to count the occurrence for the Integer 42 within the entire column "AJ"
In the sample provided "42" appears twice.

I need to be able to count how many times any integer occurs within the entire column.

Thanks for the help.

Hi,

I don't have a solution.

I'd like to have a list that states a count of how many times each integer appears.

When I un-merge the column the text string is repeated 4 times over. This returns a result of 8 instead of 2 when using the function.
I just added a "/4" to the end of the the function you provided and it seems to work, but it is non specific for single digit integers because the input of "6" in the place of "42" yields an answer of "4" when it should show a zero answer.

That looks to be perfect!

Thank you so very much.