Solution – Challenge 63 – Convert to Date Format

Below is a possible solution to the Challenge 63 – Convert to Date Format

Put following formula and drag down

=IFERROR(–SUBSTITUTE(A1,",",""),–SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(A1,",","")," ","*",2),"*",", "))