| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stripping Information
I am working with data imported from Solomon Reports, and one of the columns
comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
Assuming your "date/time" is in A1, put this in B1:
=LEFT(A1,10)*1 and format the cell as a date. Copy down as required. Hope this helps. Pete On Jan 11, 5:31*pm, Kent wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. *I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
If the data is not date/time then:
=LEFT(A1,FIND(" ",A1,1)-1) -- Gary''s Student - gsnu200765 "Kent" wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
Perhaps you could insert another column and insert the formula
=LEFT(A1,FIND(" ",A1,1)-1) The FIND function finds the index where the space occurs, and the left function displays the text from the first character up to one before the space. Drag the formula down for each date you want to strip out. Hope this helps. -- Cheers, Michelle "Anyone who says he can see through women is missing a lot." Groucho Marx "Kent" wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
Thank you!
"Pete_UK" wrote: Assuming your "date/time" is in A1, put this in B1: =LEFT(A1,10)*1 and format the cell as a date. Copy down as required. Hope this helps. Pete On Jan 11, 5:31 pm, Kent wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
Thank you!
"Gary''s Student" wrote: If the data is not date/time then: =LEFT(A1,FIND(" ",A1,1)-1) -- Gary''s Student - gsnu200765 "Kent" wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
Thank you!
"Michelle" wrote: Perhaps you could insert another column and insert the formula =LEFT(A1,FIND(" ",A1,1)-1) The FIND function finds the index where the space occurs, and the left function displays the text from the first character up to one before the space. Drag the formula down for each date you want to strip out. Hope this helps. -- Cheers, Michelle "Anyone who says he can see through women is missing a lot." Groucho Marx "Kent" wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stripping Information
You're welcome - thanks for taking the trouble to feed back.
Pete On Jan 11, 7:21*pm, Kent wrote: Thank you! "Pete_UK" wrote: Assuming your "date/time" is in A1, put this in B1: =LEFT(A1,10)*1 and format the cell as a date. Copy down as required. Hope this helps. Pete On Jan 11, 5:31 pm, Kent wrote: I am working with data imported from Solomon Reports, and one of the columns comes over as follows: 12/11/2007 00:00:00 When I look at the cell formatting, it is general, not formatted as date/time. *I want to strip the 00:00:00 and just be left with the date, is there an easy way to do this in Excel??? Thanks, Kent- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display zero in a number to 1dp e.g. 14.0 without stripping the zero | Excel Discussion (Misc queries) | |||
| Stripping The First Four Characters from a value | Excel Discussion (Misc queries) | |||
| Stripping the dashes | Excel Discussion (Misc queries) | |||
| Stripping and Conversion. | New Users to Excel | |||
| Stripping section of text | Excel Worksheet Functions | |||
Linear Mode
