text to columns will certainly fix it no need for an delimiter just select column use mdy click finish