Stripping Information

[Kent]

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

 

[Pete_UK]

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

 

[Gary''s Student]

If the data is not date/time then:

=LEFT(A1,FIND(" ",A1,1)-1)

 

[Michelle]

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.

 

[Kent]

Thank you!

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

 

[Kent]

Thank you!

If the data is not date/time then:

=LEFT(A1,FIND(" ",A1,1)-1)

 

[Kent]

Thank you!

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.

 

[Pete_UK]

You're welcome - thanks for taking the trouble to feed back.

Pete