Search Cell That Contains Specific Text

[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]

How about

+Fluff v2.xlsm
	A	B
9
10	a long 004 text string "004" with "004"	2
Main

Cell Formulas
Range	Formula
B10	B10	=(LEN(A10)-LEN(SUBSTITUTE(A10,"""004""","")))/LEN("""004""")

 

[lpw0806]

OMG THIS HELPED!!! THIS FIXED IT!!

THANK YOU SO MUCH!

 

[Fluff]

You're welcome & thanks for the feedback.