Excel (or other) macro for cleaning date data
Does anyone have a good macro for taking date data that are in a
variety of formats and making them consistent? By format, I don't mean
that the cells are formatted differently, but that the data are all
recorded as, say, a string, but they all look different, e.g.
"01/05/92"
"01-07-84"
"Jan 12, 1991"
"January 1, 2000"
"10 January '05"
Is there any macro that is written to recognize that, say, the first
two are in mm/dd/yy format and to put them into a consistent style,
that the second, third, and fourth are in different formats, and to
put them into mm/dd/yy, etc.?
|