pull specific text out of a cell

[chriswrcg]

I have a worksheet that I created by exporting data from another application. The issue that I am having is in the date and time cell. Both the date and time are being displayed in the same cell and I need to separate them.
This is what the cells are populated with.

2018-08-02T03:51:48.000Z
2018-08-02T03:46:38.000Z
2018-08-02T03:42:40.000Z

I need to take out 2018-08-02

Remove the t entirely

Take out 03:51:48

and remove .000z entirely

My goal is to have two columns. One with the date and one with the time.

Any idea hoe to do that?

[rorya]

You could use Data - Text to columns, Fixed width, and just skip the two columns you don't need (the T, and the trailing .000Z) or use formulas like:
=LEFT(F2,10)+0
and
=MID(F2,12,8)+0
and then format the columns as date and time respectively.

[modytrane]

If you just need to pull out string [as text] use this:

=LEFT(F2,10) and =MID(F2,12,8) to pull out date and time strings.

If you have to use the date string as date in other formulas then you may have to use this for date: