Formula to split Names

[rizmomin]

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

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...lit-names.html