Macro or formula on Excel to Standardize dates

[leonardo.sp05]

Hi, Guys



I really need help on this. I've been looking for an answer for a LONG time but couldn't find it. In my work, I need to sort a table on Excel using the date present on every line. The problem is that the spreadsheet I use have different layouts of dates as seen below.

2/13/2017 4:43:02 AM (MM/DD/YYYY)
02/11/2017 05:05 (DD/MM/YYYY)

I can't sort it this way because it always sort it wrongly.
What I need to do is to split cells and then concatenate them again but this is causing a lot of trouble.


Could you help me check if there's any way to do it automatically, using a macro, or at least using just a formula?

Thanks =)
Leo