Hi Everyone,
Capture.PNG
In the above image, there is a list of fruits and names.
If i enter the text as Ramu is eating Orange, under the cell Who, i need the output as Ramu and under the cell what, i need Orange.
Is there any formula for this or any vba macros available.
Thanks,
Prabhu P
Bookmarks