I have 1000s of raw data that I have pulled from SAP that came in text format.
I am trying to convert the date and timestamp to only the date so I can summarize the monthly data through the pivot table but as the date is in text pivot is not working.
I have tried "text to column" but no luck with that.
Is there a way to clean it?
I am trying to convert the date and timestamp to only the date so I can summarize the monthly data through the pivot table but as the date is in text pivot is not working.
I have tried "text to column" but no luck with that.
Is there a way to clean it?
6/14/2022 12:00:00 AM |
6/13/2022 12:00:00 AM |
6/13/2022 12:00:00 AM |
6/13/2022 12:00:00 AM |
06-10-2022 00:00 |
06-09-2022 00:00 |
06-08-2022 00:00 |
06-08-2022 00:00 |
06-07-2022 00:00 |
06-07-2022 00:00 |