Forum Discussion

palmer520325's avatar
palmer520325
Copper Contributor
Feb 13, 2024

CSV that contains Date Time, Status Code, Description 02/13/2024 09:16:34 AM America/New_York, Ready

Hi,

I have a CSV that has the following:

Date Time, Status Code, Description
02/13/2024 09:16:34 AM America/New_York, Ready, Status is ready

 

I would like to be able to open this CSV file in Excel and have it formatted into three columns: DateTime, Status Code, Description, but the first data group for Date Time has Time Zone as part of the comma delimited data.

 

Is there a recommendation that can be made to convert to just the date and time to a proper date column?

 

Regards,

 

Jim Palmer

Excel on Mac

1 Reply

Sort By
  • mathetes's avatar
    mathetes
    Silver Contributor
    Feb 13, 2024

    palmer520325 

     

    Use this formula (adjusted for whatever cell references are relevant in your situation), and then the special formatting feature shown below to format the resulting number as date and time.

    =VALUE(LEFT(A1,19))

     

     

     

     

Resources