Formula to find text in a cell - Looking for the formula

[okjam]

Hi,

I have a string of text which reads like
"START, PAUSE, GO, PAUSE, STOP"

Im basically now looking for a formula which will give either a yes/no/true/false answer to whether a text cell contains certain information (and even better if i can tell you if the cell contains the infomation more than once)

I.E
Is there a formula that would check if there if a cell contains (in this case) "PAUSE" twice

Ive heard of FIND/SEARCH functions but don't know how to use it in the way i am looking for (if possible)

Any help appreciated

[TMS]

One way to check cell A1:

=IF((LEN(A1)-LEN(SUBSTITUTE(A1,"PAUSE","")))/2=LEN("PAUSE"),"in twice","")


Regards,TMS

[okjam]

Excellent !
Just what i needed.
I dont really understand the formula but its what i need
Thank you !

[Haseeb Avarakkan]

You can use "*" in SEARCH, like

=IF(ISNUMBER(SEARCH("Pause*pause",A1)),"Yes","No")

[okjam]

TMShucks
Actually - This is great.
But I have a few examples where i have PAUSE in the text more than twice, and using the above it returns a blank cell because it doesn't contain exactly 2.
Is there a way this can be adapted so it shows if the cell contains PAUSE more than once?

Sorry! :{

[okjam]

You can use "*" in SEARCH, like

=IF(ISNUMBER(SEARCH("Pause*pause",A1)),"Yes","No")

This answers my last question

Thanks BOTH!

[TMS]

=IF((LEN(A1)-LEN(SUBSTITUTE(A1,"PAUSE","")))/2>=LEN("PAUSE"),"in more than once","")

Regards