How to count partial matches in single cell with multiple concatenated values?

Good night,

Could anyone help me to find out how to look for the number of times a specific text or character appears as a substring inside a cell?

I have a column populated with multiple concatenated SKU in each cell/row. Sometimes it could have 1 single code, or dozens, but they have the same lenght and carry a ";" separator. I need to count the number of items in each cell, therefore I thought I could count how many ";" there are. In another situation I need to count different parts of the code, as it's built combining different other codes, but follows a 4 char lenght pattern (3 numbers + 1 letter).

I tried using the following formula to count with wildcards, but it seems to count only 1 occurence, no matter what:

Please Login or Register  to view this content.

Example of a single string:

Please Login or Register  to view this content.

I tried using a reference cell instead of writing it, but it gives me the same result. One other thought I had was about counting the lenght of the string and dividing it by the lenght of each code, as they are always the same lenght, but I was actually trying to avoid that and hoping I could get around with something like above.

Any help is appreciated. Thanks in advance.

To count ; try this...
=LEN(A26)-LEN(SUBSTITUTE(A26,";",""))

To count specific string eg 00 try this...
=(LEN(A26)-LEN(SUBSTITUTE(A26,"00","")))/2

the /2 is because I am searching for just 2 characters - adjust that as needed

Hello FDibbins,

Sorry for the delay, been in a rush, and thanks for the reply!

The second formula you provided is exactly what I need and I did manage to adapt it for my use. Thank you a lot for your help

Happy to help and thanks for the feedback