Does a cell contain a particular text?

[Sheridi]

What is the easiest way to determine if for Cell A1 contains a particular text? The cell most likely will contain one or two 2 to 3 character words separated by commas I don't care where my search text is in the cell, I just want to know is it there?

Thanks

 

[Sheridi]

Meant to write . . . "if Cell A1". . . . . .

 

[Jonmo1]

Try

=COUNTIF(A1,"*particulartext*")>0

True means particulartext exists within A1
False means it doesn't.

 

[CamFlawless]

This will return FALSE when the string of interest in not found, TRUE when it is.

=ISNUMBER(SEARCH("stringofinterest",A1))

NOTE: the above formula is NOT case sensitive. If you prefer the string of interest to be case sensitive, replace SEARCH with FIND.

 

[ExcelWhizzDotCom]

For a more visual method you could use conditional formatting Format Excel cells which contain specific text – Excel Whizz

 

[Sheridi]

That will work. Thank you.

 

[Jonmo1]

You're welcome.