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!
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!