DataText to ColumnsFixed width.

Drop a line down after the 8th digitNext

Column Data formatdateYMD

Select right column and "do not import" then Finish.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 12:17:04 -0700, mebsmith
wrote:



"mebsmith" wrote:

I have cells with the following info:

4/14/2003 14:35

but i need to split so that i can sort by date alone.


I also have cells with dates in the form:

20030416000927

where the date is the first 8 numbers. How can i extract that out?

Thanks
how can this be done? i have tried just taking out the data, but that just
treats the "/" as a dividing sign and so get weird numbers.

thanks in advance