Hi All,

I am using the following formula to find the word 'Purfleet' from a strong of data.

I'd like to also find the word 'scrap' as well. Is that possible with the formula I'm using?

=IF(ISNUMBER(SEARCH("*Purfleet*",G481)),"Purfleet","")