I had this question after viewing how to convert m/d/yyyy to d/m/yyyy
please see attached example dummy file, i need a macro to to clean up the messed data input.
there are two worksheets in the attached workbook. Sheet called "messedup" is what i have right now.
the sheet "Cleaned" is the desired solution that after i run the macro it should give me that.
any help is appreciated.