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.
New contributor
Arnob Rahman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.