Excel check if cell contains partial text from another

Excel check if cell contains partial text from another pictures 5

Home > Excel check if cell contains partial text from

Excel check if cell contains partial text from another

excel check if cell contains partial text from another cell