Do a DataText To Columns with a delimiter of space

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Max_power" wrote
in message ...

Hello,

I've got a cell that contains something like
132432 1/1/06
I'm looking to make this into two cells
ie 132432 in one cell and 1/1/06 in another.
I know *=mid(A#,3,1024)* returns the latter half but how Can I return
the first half also?

Many Many thanks for any help


--
Max_power
------------------------------------------------------------------------
Max_power's Profile:
http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=543240