Categories
Uncategorized

Check if part of a cell matches specific text

o do this task, use the IF, SEARCH, and ISNUMBER functions.

Note: The SEARCH function is case-insensitive.

Formula:

=IF(ISNUMBER(SEARCH(“syringe”,G4)),”Check”,””)