Forum Discussion

lucas_h's avatar
lucas_h
Copper Contributor
Apr 04, 2020
Solved

Return value Y/N if text is within a cell.

Good morning Microsoft Tech Community, I am fairly new to Excel and quite amazed at how powerful this tool can be.  I figured there would be no better place to find an answer than here!    What fu...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 04, 2020

    lucas_h Try this in A1 and copy it down.

    =IF(ISNUMBER(SEARCH("yel",A1)),"Y",0)

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 04, 2020

lucas_h 

For the collection

=IF(COUNTIF(A1,"*yel*"),"Y","0")

Resources