Many thanks Maffew will try that tomorrow. Thst looks incredibly neater than the donkey solution I came up. With a focus in initially getting rid of the day of the week I used Excels Text to Columns feature but did not import the weekday column. I then used the Concantenate to combine the...
I have a training database that rather unhelpfully exports to Excel the date of training as a string in a single cell " Monday 2 November 2017 ". I'm not interested in the day of the week but just want to convert to date format 02/11/2017 thereby allowing sorting or use in pivot table.