Need Help to extract Designation for the String Data

[abid.aries]

Dear Experts, I need your help for getting designations from this messy data. In this data "Saif Ullah SafiInchargeJ.D: 2/1/2012" [Incharge] is the designation upto "Saif Ullah SafiInchargeJ.D: 2/1/2012" "Waseem UddinPaper ManJ.D: 2/28/2012" Muhammad ImranMasterJ.D: 2/1/2012 "Muhammad AamirSample ManJ.D: 2/9/2012" "Naeem KhanEmb Sample ManJ.D: 2/24/2012" "M Shakeel ArainEmb Sample ManJ.D: 2/1/2012" "Muhammad YaqoobEmb Sample ManJ.D: 2/24/2012" This is the sample data kindly help me plzzzzzzz..... Thanks in advance

 

[abid.aries]

https://www.dropbox.com/s/96kbvkvxmlulusc/data.xlsx Dear Users this is the link to the excel file and also attaching file for your working

 

[NARAYANK991]

Hi Abid ,

Check your file now.

Narayan

 

[abid.aries]

Thanks Dear Narayank991, You are always helpful to all you encounter such painful problems