Another possibility
To clean "dirty" data, you can use
Code:
=TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," ")))
in col E
and to make it real dates in col F
Code:
=DATE(RIGHT(E2,4),LEFT(E2,2),MID(E2,4,2))
and pull down
you can skip the second step this way :
- copy results of col E
- Paste values somewhere say col F
-select the range in col F
-Select Data Text to columns - Next - Next
- In the last window set the date format to MDY and click Finish - If results are right aligned you're good
( Can't say this is much easier... :-))))