Search results

Cool let me know if it works. Only thing is if you pivot it by date it may do it alphabetically so 01 Jan 01 Feb........ Unless its a business requirement to dd/mm/yyyyy (which breaks a lots of countries dates/stops working after the 12 each month) I would use the ISO standard yyyymmdd or...

=TEXT(RIGHT(A1,LEN(A1)-FIND(" ",A1))*1,"dd/mm/yyyy")