I need a formula to extract text as follows in Col A
eg Transfer from BR1 Call to BR4 Call********************
1) In Col B In need to always extract the text starting from "to" onwards eg to BR4 call
2) In Col C In needs tom extract text "from" up to the first text containing "Call" eg from BR1 call
I have attached sample data as well as what the data should be in Col B & C
It would be appreciated if someone could assist me
Bookmarks