Excel: Extract a specific word from Sentence

Below is the Code which I need to extract from C021_CBVMKR I need to extract the above from below C021_Enquiry_CBVMKR I tried the below formula but its not working :( Please help =LOOKUP(2^15,SEARCH(C1,A1),A1)


This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of May 01, 2015.

For more resources for Microsoft Excel