Forum Discussion
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 Ex...
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))