search for word in string of text = true or false?!

[cashflowpro]

Hi.

I'm searching for words in strings of text, if true one thing, if false something else.

say this is my list:

product1
Total product2
product2
product2 total
product3
product3 TOTAL

(exciting list, huh)

I'd like a yes or no answer as to whether the string contains word 'total' for example, whatever case that may be.

Suggestions>?

[VBA Noob]

Try

=ISNUMBER(SEARCH("total",A1))

VBA Noob

[cashflowpro]

well thanks again noob, that's worked a treat!

I think I like this forum!