Hello
Please refer to attached file. ( Note : I have asked for VB code but wonder if this can be achieved thru Formula approach)
I have Drug Names as shown in column B
I need formula to split out the name as shown in Column C (DrugName),D (Strenth) and E (Unit).
Formula needs to search for last word in a drug with one from the list in Column J.
I have manually created few samples in RED font.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks