Delete Text in Multiple Cells

[hbcobra]

Hello,

I have a column of cells where both a date and time are included i
each. For example, "01/17/2007 12:13:14" (everything is in th
"mm/dd/yyyy hh:mm:ss" format). I would like to delete the time stam
from each cell but leave the dates. How do I do that?

Thank yo

 

[Kevin@Radstock]

Hi hbcobra

To extract the data as a date, assuming the data is in A1:
=INT(A1) & format the cell as "dd/mm/yyy" or how ever you require.
To extract the date as a text value:
=TEXT(A1,"dd/mm/yyy") change the format to suit your requirement.

Kevin

 

[Living the Dream]

Hi

Depending on which version of Excel you are using:

< 2010:

Tools | Format Cells | Number Tab

2010:

Format | Format Cells | Number Tab

Choose Date, select whichever Display format you like including a custom
format of your own choosing.

HTH
Mick.

 

[Claus Busch]

Hi,

Am Fri, 22 Mar 2013 20:38:31 +0000 schrieb hbcobra:

I have a column of cells where both a date and time are included in
each. For example, "01/17/2007 12:13:14" (everything is in the
"mm/dd/yyyy hh:mm:ss" format). I would like to delete the time stamp
from each cell but leave the dates. How do I do that?

if formatting as "mm/dd/yyyy" is not that what you want, you can try
TextToColumns => Delimited => Delimiter = Comma => select the column
with the time and choose "Do not import (skip)"
Then your date and time
01/17/2007 12:13:14 changed to
01/17/2007 00:00:00 and you only have to format the column as date


Regards
Claus Busch