Thread: Splitting Column Data into 2 fields
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Splitting Column Data into 2 fields
If I understand you correctly try the following:

=IF(A2="","",TEXT(A2,"mm/dd/yyyy hh:mm:ss"))

Reply With QuoteReply With Quote