Search within cell

  • Thread starter Thread starter Gee...
  • Start date Start date
G

Gee...

I need to search within a cell. I'm searching for the word
"fuse"...sometimes they leave off the "e" or add "ing" so I'm really
searching for "fus".

I want to go into Column C and say something like:

"If B1 contains "fus" then Yes else No."

B1 might contain something like:
"Replaced fuses in main generator" or
"A7438Bfuse" or
"Tray fusing aligned"

Thank you in advance for your help.
G
 
One way:

=IF(COUNTIF(B1,"*fus*"),"Yes","No")

alternative

=IF(ISERR(SEARCH("fus",B1)),"No","Yes")

another:

=COUNTIF(B1,"*fus*")

and custom format the cell (Format/Cells/Number/Custom: "Yes";;"No")
 
Back
Top