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

[James Palmer]

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

[#2]

@James Palmer 

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