Formual require for formatting the text columns.

Hi,

Please find the attachment.

I have prapared a formula for B2,B3 and C2,C3 and the reult came in B10,B11,C10,C11 and D10,D11,E10,E11.

From that relust i want to get the final result should be as follows.

B10 should again divided in to anil(in one cell) and 16/12/2013 11:33:50 (in another cell). This formula to be added in B10,B11,C10,C11 and D10,D11,E10,E11 formula.

I have mentioned in the excel what i am looking is there any possiblity then please try to right a formula becuase i am not good in macros.

Thanks in advance.

Regards
Kasi