Formula to split text into seperate cell

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in column A.
I need formula in column B thru E to split as shown

Let me know if you have any questions.
Thanks.

Riz

[jtakw]

Hi,

Assuming the Date is always in that 10 character format, in B2 copied down, format result cells as Date:

Please Login or Register  to view this content.

In C2 copied down:

Please Login or Register  to view this content.

In D2 copied down and across to Column E:

Please Login or Register  to view this content.

See attached.

[rizmomin]

Hello jtakW:

Great work, thanks

Riz

[jtakw]

You're welcome, thanks for the feedback.