commonly people use to search directly inside the cell using SEARCH function, but that only give you the text position for the first occurrence
but we can search for two different string in one cell by combining two function COUNT and SEARCH, and string to search typed as array
and excel will give you the right answer for the occurrence of the text string
