Well, technically, T to C will parse the data if it is a DATE/TIME but look
at how it ends up!

Biff

"Biff" wrote in message
...
6/12/2006 9:30

If the entry is a real Excel DATE/TIME there is no space!

There would only be a space if the entry was TEXT.

Biff

"VBA Noob" wrote
in message ...

Have you tried

Data Text to Columns. Delimiter will be space.

VBA Noob


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