I appreciate your help. Problem solved.

"N Harkawat" wrote:

> Use this formula assuming that the text is on cell A1
> =--ISNUMBER(SEARCH("clutch",A1))+(--ISNUMBER(SEARCH("brake",a1)))
> all values = 2 is your answer
>
>
>
> "eddie" <eddie@discussions.microsoft.com> wrote in message
> news:C5C3BF55-2AC5-4E32-842F-79AF8C4D40EA@microsoft.com...
> > How do you search for multiple words in any given cell. The order of the
> > words being searched does not matter.
> >
> > i.e. If I am looking for the words 'brake' and 'clutch':
> >
> > 1 "John's Brake and Clutch"
> > 2 "Jerry's Clutch Repair"
> > 3 "Impact Clutch/Brake"
> > 4 "Brakes and Clutches r Us"
> >
> > If want the search to work for 1, 3, and 4. Any ideas?
>
>
>