Doing stuff for work, and while I’m good at excel I’ve no idea how to do this or if it can be done.
I’ve got a file with a date in a column. It’s in a shit format (2021-04-10T17:43:42+00:00) this gives date and time when ordered. I want to remove the time, so from the t onwards. I can do this manually at the minute as there is only 24 rows but if this takes off there could be hundreds.
Is there a way to remove the shit I don’t want with a command/script/query? Anyone know?