Hi Everyone,
I need help in excel. Please find below for example:
<tbody>
A
B
C
D
1
Vikas Agarwal John Monty
2
Parul sharma Brown Peter Chris
3
4
</tbody>
i want to take all words mentioned before John/Peter. so my B1 should be Vikas Agarwal and B2 should be Parul...