Excel if contains partial text copy to another cell

Excel if contains partial text copy to another cell pictures 5
Home > Excel if contains partial text copy to another

Excel if contains partial text copy to another cell