Hello,

I have an excel spreadsheet with date and time in the same cell. My question is how do I separate thos data and put them into two different cells ?

The data looks like this:

1999-06-30 18:26:31

Then, I have to erase informations concerning seconds.

Any suggestion ?