How to matching substring from a Cell

[ªÎ¿°¤H@work]

Dear Sir/Madam,

I am now having a column likes below

Column A
My Name is David Chan
Marry
David Williams
He is David and is a boy

I want to find out Column A cells with contact the word "David', then
display "T" on Coloum B if found or "F" is not found. The result should be
as following:

Column A Column B
My Name is David Chan T
Marry F
David Williams T
He is David and is a boy T

How can I do it ?
I have tried if( ), but it only match the cell with only input "David" in
it.

Thanks for help.

Regards,
William

 

[T. Valko]

Try this:

=IF(COUNTIF(A1,"*David*"),"T","F")

Copy down as needed.

 

[Rick Rothstein]

Try this formula...

=IF(ISNUMBER(SEARCH("david",A1)),"T","F")

 

[AltaEgo]

=IF(ISERROR(FIND("David",A1)>0),"F","T")

 

[ªÎ¿°¤H@work]

Thanks all for help.