|  | How to matching substring from a Cell | | |
| | | ªÎ¿°¤H@work |  |
|  Posted: Tue Sep 02, 2008 12:03 am Post subject: How to matching substring from a Cell |  |
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 | |
| | Posted: Tue Sep 02, 2008 12:08 am Post subject: Re: How to matching substring from a Cell | |
Try this:
=IF(COUNTIF(A1,"*David*"),"T","F")
Copy down as needed.
--
Biff
Microsoft Excel MVP
"ªÎ¿°¤H@work" <fatguy@fatguy.com> wrote in message
news:OIRxVAKDJHA.1628@TK2MSFTNGP02.phx.gbl...
| Quote: | 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
|
|
| |
| | | Rick Rothstein | |
| | Posted: Tue Sep 02, 2008 12:11 am Post subject: Re: How to matching substring from a Cell | |
Try this formula...
=IF(ISNUMBER(SEARCH("david",A1)),"T","F")
--
Rick (MVP - Excel)
"ªÎ¿°¤H@work" <fatguy@fatguy.com> wrote in message
news:OIRxVAKDJHA.1628@TK2MSFTNGP02.phx.gbl...
| Quote: | 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
|
|
| |
| | | AltaEgo | |
| | Posted: Tue Sep 02, 2008 12:15 am Post subject: Re: How to matching substring from a Cell | |
=IF(ISERROR(FIND("David",A1)>0),"F","T")
--
Steve
"ªÎ¿°¤H@work" <fatguy@fatguy.com> wrote in message
news:OIRxVAKDJHA.1628@TK2MSFTNGP02.phx.gbl...
| Quote: | 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
|
|
| |
| | | ªÎ¿°¤H@work | |
| | Posted: Tue Sep 02, 2008 1:25 am Post subject: Re: How to matching substring from a Cell | |
Thanks all for help.
"ªÎ¿°¤H@work" <fatguy@fatguy.com> ¼¶¼g©ó¶l¥ó·s»D:OIRxVAKDJHA.1628@TK2MSFTNGP02.phx.gbl...
| Quote: | 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
|
|
| |
|
|
