separating date and time
Hi,
Am Wed, 24 Apr 2013 16:38:02 -0400 schrieb wabbleknee:
A
1 04/01/2013 12:00:00 PM
2 04/03/2013 09:00:00 AM
3 04/03/2013 01:45:00 PM
I would like to have the resulting data to look like this
A B
1 04/01/2013 12:00
2 04/03/2013 09:00
3 04/03/2013 13:45
select column A = TextToColumns = Delimited = Delimiter is Blank
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|