Separate cell

[Max_power]

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 retur
the first half also?

Many Many thanks for any hel

 

[Bob Phillips]

Do a Data>Text To Columns with a delimiter of space

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)