New
#1
Cells contaning Fri 16 Jul 10 and similar as text
I have a s/sheet ( Excel2007), whose source data was taken from a link. The date column is in the format as per title. In that form it will not sort itself or associated columns in to date order. Has anyone a way to make the data in the column sort itself as I want?
Also with the example given, how with text to column function does one make just two columns, one with just the weekday and the other with day, month, year?