Pulling data from a string in a cell

[MSP]

I have to put together a spreadsheet that lists the brand dame and product description in seperate tabs. Unfortunately, the brand name and description are wedged together in one cell (EXAMPLE: 13oz, 3 quantity Goya refried beans). What formula can I use to pull 'Goya' from the string and put it in another cell ( Something like =IF(C4 contains "Goya" in the string then C2 = "Goya))

Any help on this matter would be greatly appreciated.

Thanks,

MSP

[davesexcel]

This is a can of worms about to be opened, because Goya is not the only product you want to search for....
To avoid wasting valuable time, supply a sample workbook, including the products you want to search for.

[JBeaucaire]

Put this in C2:

=IF(ISNUMBER(SEARCH("Goya", C4)), "Goya", "")

...but as Dave mentioned, I imagine this is just the beginning... ugh.