Seperate Data in one column into two columns?

D

Dan B

Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!
 
R

RagDyeR

With data in Column A,
In B1 enter
=A1
and copy down as needed,
Then, custom format Column A to perhaps
mm/dd/yyyy
AND
Custom format Column B to perhaps
hh:mm AM/PM
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!
 
D

Dan B

This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?

Thanks.
 
S

Scoops

Dan said:
This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?
Click to expand...

Hi Dan B

Try this:

Select the cells containing the data.

Click Data > Text to Columns.

Click Delimited, click Next

Uncheck Tab, check Space, click Finish.

Regards

Steve
 
Top