View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Constance Constance is offline
external usenet poster
 
Posts: 14
Default Rearranging data in one column into two columns

I have some dates and times in one column that I would like to line up the
dates with the times in the adjacent column. Please see example below:

Present display Would like displayed as this
5/31/07 5/31/07 11:30
11:30 5/31/07 13:20
5/31/07 6/1/07 10:30
13:20 6/1/07 15:30
6/1/07
10:30
6/1/07
15:30

I apreciate the assistance.
--
Constance