Delete Text in Multiple Cells
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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|