Search a cell to see if it contains a specific string [TRUE/FALSE]

[The_Fray]

Hello,

I am trying to figure out the easiest way to determine whether a cell has a specific string of letters (case insensitive).

For example, in the following table, I want to know if the string "leader" is contained in the phrase cell. So it needs to pick up variations like "Leadership", "Leader", 'leader'.

How would I go about doing that? All I need is a True or False output. 

Thanks,

Frazer

[kylemhabe · Accepted solution]

Try this:

[Eswaran]

It does not works now.. Can you provide me sample workflow?