Perform search for a one letter match.
 

Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y or
true in another cell from the same row. Is there a formula to perform this
task?
Thank you in advance for your help!

Perform search for a one letter match.
 

Assuming your data starts in Row 2, put this in Row 2 of whatever column you
want your "Y" to be shown in and copy it down...

=IF(COUNTIF(F2,"*Q*"),"Y","")

--
Rick (MVP - Excel)


"binh" wrote in message
...
Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y
or
true in another cell from the same row. Is there a formula to perform
this
task?
Thank you in advance for your help!

Perform search for a one letter match.
 

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")
Non-case-sensitive
=IF(ISNUMBER(SEARCH("q",F2)),"Y","N")

Copy down as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"binh" wrote:

Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y or
true in another cell from the same row. Is there a formula to perform this
task?
Thank you in advance for your help!

Perform search for a one letter match.
 

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")

Case-sensitive? Hmmm


"Luke M" wrote:

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")
Non-case-sensitive
=IF(ISNUMBER(SEARCH("q",F2)),"Y","N")

Copy down as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"binh" wrote:

Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y or
true in another cell from the same row. Is there a formula to perform this
task?
Thank you in advance for your help!

Perform search for a one letter match.
 

Argh, you got me! Forgot to change the function to:
=IF(ISNUMBER(FIND("Q",F2)),"Y","N")

Thanks for pointing that out!

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Teethless mama" wrote:

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")

Case-sensitive? Hmmm


"Luke M" wrote:

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")
Non-case-sensitive
=IF(ISNUMBER(SEARCH("q",F2)),"Y","N")

Copy down as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"binh" wrote:

Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y or
true in another cell from the same row. Is there a formula to perform this
task?
Thank you in advance for your help!

Perform search for a one letter match.
 

Thank you again for your help, and it works!
Regards,
Binh
--
Thank you in advance for your help!


"Luke M" wrote:

Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")
Non-case-sensitive
=IF(ISNUMBER(SEARCH("q",F2)),"Y","N")

Copy down as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"binh" wrote:

Hello all,

I'm looking to find one letter "Q" in column F (value is F has mix # and
letter that can range from 5 to 10 characters), and then return the as y or
true in another cell from the same row. Is there a formula to perform this
task?
Thank you in advance for your help!