View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Concatenate Custom Dates and Times

=a1+b1
and format as mmddyyyyhhmm
(With dates in column A and times in column B)

MadHydroSavant wrote:

I have two columns with custom formats mmddyyyy and hhmm. I need to combine
them to create mmddyyyyhhmm. The file will ultimately be saved as a .csv


--

Dave Peterson