In excel cell A1 “Mr. David Hudson” and in cell B1 “Mr. David John” is mentioned and in cell C1 i want the result “Hudson” “John” both mentioned
In excel cell A1 “Mr. David Hudson” and in cell B1 “Mr. David John” is mentioned and in cell C1 i want the result “Hudson” “John” both mentioned. Because “Hudson” is missing in cell B1 and John is missing in cell A1.