Perform search for a one letter match.

  • Thread starter Thread starter binh
  • Start date Start date
B

binh

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!
 
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","")
 
Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N")
Non-case-sensitive
=IF(ISNUMBER(SEARCH("q",F2)),"Y","N")

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

Thanks for pointing that out!
 
Back
Top