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)

C021_Enquiry_CBVMKR #VALUE! C021_CBVMKR


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