splitting date and time information in cells
 

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.

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

splitting date and time information in cells
 

If these are real dates/times, you could use:
=int(a1)
to get the date -- format it as a date.

and if you wanted
=mod(a1,1)
to get the time -- format it as time



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.

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

--

Dave Peterson

splitting date and time information in cells
 

=Int(A1) ' provides Date

=A1-Int(A1) ' provides Time



"mebsmith" wrote in message
...
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.

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

splitting date and time information in cells
 

"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

splitting date and time information in cells
 

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

splitting date and time information in cells
 

thanks!

"Gord Dibben" wrote:

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