There's really *no* need for *any* formulas - *except* for the one to copy
the data to the adjoining column:

If A1 contains "6/12/2006 9:30" (no quotes)
Then in B1 enter
=A1

And the rest is accomplished with simple formatting!

A1 = m/d/yyyy
And
B1 = h:mm

And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"inveni0" wrote in
message ...

VBA Noob Wrote:
Have you tried

Data Text to Columns. Delimiter will be space.

VBA Noob


Works like a charm! Thanks, man!


--
inveni0
------------------------------------------------------------------------
inveni0's Profile:
http://www.excelforum.com/member.php...o&userid=31178
View this thread: http://www.excelforum.com/showthread...hreadid=562643