View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan B
 
Posts: n/a
Default Seperate Data in one column into two columns?

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!!