| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting information in cells | Excel Worksheet Functions | |||
| Splitting Date and Time | Excel Discussion (Misc queries) | |||
| Sumif a date time colum and information | Excel Discussion (Misc queries) | |||
| How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
Hybrid Mode
