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