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!