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 loooking for the final reslt, i have explain the in the excel. I reuired the final result with single formula from B2,B3 and C2,C3.

Please try to right a formula becuase i am not good in macros.

Thanks in advance.

Regards
Kasi