Mixed Date column (More complicated than mm/dd/yyyy to dd/mmm/yyyy ..... !)

[Karly21]

Hi guys,
Long time lurker, and have benefited greatly of your questions/answers. I am at a very basic VBA level, but have managed some nice stuff with resources like in this forum. (Anyway, thanks in advance for the knowledge already shared). This is the actual first time that I am totally lost. So here it goes.

I have one column with SEVERAL date formats, including: (they look as this in the cell)
Aug-10-2018
Aug-20-2018 15:15
07/27/2018 00:00
Sep-17-2018 13:56
Thursday, September 27, 2018 at 12:12

I need the format to be dd/mm/yyyy hh:mm

As you see, there are lots of problems, the lack of standardization on the dates formats being only one of them. I cannot get my head around this at all, and don't know even where to begin. Sorry I don't have any proof of my attempts to solve this, but I literally only got to separating all of these in columns... and then get no idea what do do afterwards! Even if not with VBA, any solutions will be greatly appreciated.

Thanks to you all kind souls!

 

[Bobjg]

You are very welcome. Thanks for the follow-up.

Apart from the way mole999 has suggested, you can always do it the way you did in posts 16 & 17 by 'quoting' something that person has said, just as I have done here too.

As it happens, my comment about addressing people directly was not directed at you but to Bobjg, as you can see by my quote of theirs immediately above my comment in post 15.