Search Cell for Specific Text (and count how many times it shows up)

[lpw0806]

I have a cell with a long text string. I need to count how many times the value "004" (quotes included) shows up. I tried the search function, but it doesn't work with quotes. Also, it will only tell me if "004" exists in the cell, not how many times "004" shows up.

Any help would be so appreciated!!

THANK YOU!

 

[Fluff]

Duplicate Search Cell That Contains Specific Text

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).