Check string in a cell

[Manolocs]

Hi, I need to check if there is a word inside a text in a cell:

cell O5 = tomatos/rice/sugar/meat

AC5 =ISNUMBER(SEARCH("/rice", O5))

This formula gives me TRUE/FALSE

Instead of TRUE/FALSE I need the result if TRUE = tomatos/rice/sugar/meat

if FALSE = "" empty.

Any hint?

 

[Marcílio_Lobão]

Manolocs, Good morning.

Try to use:

AC5 --> =IF(ISNUMBER(SEARCH("/rice", O5)),O5,"")

I hope it helps.

Have a nice day!

 

[Manolocs]

Exactly what I need thanks. Obrigado

 

[Marcílio_Lobão]

Thanks for the feedback.

Have a nice weekend!