I have been trying to extract the required data from a single cell and i have made a try to using some common formulas but its not working for all the cells exactly.

I would appreciate your help in this regards.