Peo

Unfortunately on Office 2007 and the data that was presented the obvious mmm
yy didn't work nor did =INT(A2) - curious I know, but nothing is ever simple,
but it keeps us on our toes.

Rik

"Peo Sjoblom" wrote:

Or just custom format A2 as mmm yy.

If you really want to separate the date you can also use

=INT(A2)






--


Regards,


Peo Sjoblom


"Rik385" wrote in message
...
I realise that this thread is old but I have just come across a similar
problem.

Our own reporting system throws out time and date stamped data and when
pasted in to excel I was having dificulty converting 2007-10-18 10:18:58
into Oct 07. Suggest anyone with similar problems tries =TEXT(A2,"mmm yy")
extremely simple but hard to find.

If this does not work straight away convert the cell to columns and then
concatenate the date elements (ignoring the time elements), then try teh
above formula.

Hope this helps someone

"JT" wrote:

I need to be able to separate the Date and Time from thousands of entries
that are list as follows:

2/6/2005 2:36:45 PM

If the above is in the same cell, how can I get 2/6/2005 separated out
into
its own cell?

Thank you.