I have a column of dates in the format “Tue Jun 1 09:15:00 AEST 2021”. I ultimately want to sort this column. Can I convert this text to date, or is there another way to sort it?
Was thinking firstly to remove the day name (Mon Tue etc) and also the timezone (AEST) might help but I’m new to Calc and don’t really know how to fiddle with data in cells…
Thanks for any help.