Hi Members of this awesome Forum group,

I need assistance in sorting my excel document for mixed cell data.

I wish to sort by Date but have Date and A-Z in the same cell..

E.g. If i want the following Cell data on the left to look like the right.
Do i sort it by changing values in the custom list? (i have tryed sorting by day/month/year, or

22/02/2017 KT 22/02/2017 KT
20/04/2017 SA 30/03/2017 ST
21/04/2017 SA 31/03/2017 ST
23/05/2017 SA 20/04/2017 SA
24/04/2017 AD 21/04/2017 SA
26/05/2017 SA 24/04/2017 AD
30/03/2017 ST 23/05/2017 SA
31/03/2017 ST 26/05/2017 SA

Any help in the matte would be awesome

p.s. i'd rather not add any other columns in to assist in this sorting process.