Format Dates - Time Zones

[nniedzielski]

I have a sheet that has the dates formatted like this:

2021-06-09 17:00 America/Chicago

2021-06-10 17:00 America/New_York

2021-06-17 08:00 America/Indianapolis

2021-06-09 13:00 America/Chicago

what would be the quickest and easiest way to get this trimmed down to just the date? Removing time and the country and cities

 

[Fluff]

How about

=LEFT(A2,10)+0

 

[nniedzielski]

How about

=LEFT(A2,10)+0

That works, but i have to insert a column, do this step,copy the formula down, copy and paste as value, ensure its formatted as a date. Is there a way to just remove the whole section from the column without any further steps?

 

[Fluff]

You can use text to columns, fixed width, set first break at position 10 & clear any others, next, select column 2 in the data preview & click do not import, Finish