I am working with a really messy excel output from a data warehouse. In cleaning it up into something workable I am wondering if there is a way to count the number of occurrences of a few specific numbers within a single cell.
See the attached spreadsheet to see what I am working with and what I am trying to accomplish.
In cell A2 the numbers 12, 13, 14, 15, and 16 occur repeatedly, separated by semi colons and in varying amounts. I would like to find a formula or formulas that will count the number of 12s, the number of 13s, the number of 14s, the number of 15s and the number of 16s that occur within the cell.
Any suggestions?
Thanks!
Bookmarks