Text to Column Issue

[Andy0311]

Hello,
I have a long column of combined date and time. Here is a portion of it:

What I need is two columns, one of the date, and one of the time. I've tried using the Text to Column function (Delimited, space delimiter), and the preview looks just like I would like to see it:

But, when I click on Finish I get this:

The desired result was the date only, yet I still get the trailing 0:00 after the date. Either I am not using the Text to Column function properly or it's the wrong function to use. Any help that someone might give me would be greatly appreciated. Thank you. A

 

[Joe4]

That is just the date format. Just change the format of the column to one that only has dates and no times.

 

[Andy0311]

I changed the column format to short date, and it removed the times. Then I used the column in a pivot table and when I ran it, I still got the time attached to the date.

See the yellow times. I was hoping to see just 8/25/2020, 8/26/2020, 8/27/2020, and so forth. What seems to be wrong with what I am doing. Thanks. A

 

[Joe4]

I changed the column format to short date, and it removed the times. Then I used the column in a pivot table and when I ran it, I still got the time attached to the date.

OK, you misunderstood what I meant.
Changing the format of the cells does NOT change the value. It just changes what it looks like.
You still need to do the "Text to Columns" to remove the times. "0.00" means there is no more time piece. So we just apply the new date format (the one without time) AFTER we do the "Text to Columns" step.

 

[Andy0311]

Thank you so much for helping me. I appreciate the assistance. A

 

[Joe4]

You are welcome.
Glad I was able to help.