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