I need help in excel. Please find below for example:
Vikas Agarwal John Monty
Parul sharma Brown Peter Chris
i want to take all words mentioned before John/Peter. so my B1 should be Vikas Agarwal and B2 should be Parul...