Tx Claus, here are my results, testing one cell:

A3 = 04/03/2013 01:45:00 PM
A3 is selected, TextToColumns
Delimited is selected
Selected data shows 4/3/2013 01:45:00 PM
Next, , All Delimiters are not selected (blank)
data preview = 4/3/2013 01:45:00 PM
Next, general format, destination B1
B1 = 4/3/2013 13:45 in same cell
The fx(function) window shows 4/3/2013 1:45:00 PM

Cannot get them separated. Tx for additional help





"Claus Busch" wrote in message ...

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