Find a specific word in a string of text.

Question

Level 1

4 points

I am seeking to write a formula in Numbers. I need to search a cell of text to see if a specific word exists and if so then do "X"

Mac mini, OS X 10.10

Posted on Dec 1, 2019 7:27 PM

Reply

Answer 1

Top-ranking reply

Level 7

21,939 points

Hi snewcom,

Another way.

Formula in C2 (and fill down)

=IFERROR(SEARCH(C$1,B2,1),0)

SEARCH inserts the starting position of the keyword in the string.

If the keyword is not found, IFERROR inserts 0

Formula in D2 (and fill down)

=IF(C2>0,"X","")

Regards,

Ian.

Reply

Answer 2

Level 8

37,550 points

One ways to use COUNTIF with the * wildcard, something like this:

=IF(COUNTIF(A2,"*"&B$1&"*")>0,"X","")

Substitute ; for , in the formula if your region uses , as a decimal separator.

SG

Reply

Similar questions