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”,””)
With below formula you can check ending space in excel cell: =IF(RIGHT(a1,1)=” “,”Check”,””) =IF(RIGHT(Cell,1)=”Space”,”Check”,”False”) HPC-General Best Sellers