Convert text to date format

[klllmmm]

I have a column consisting date details. But its just entered as texts.
How do I make it to a date format.

Thank you very much for your valuable time..

July 17, 2015
August 4, 2015
August 23, 2015
July 21, 2015
July 13, 2015
October 18, 2015<strike></strike><strike></strike><strike></strike><strike></strike><strike></strike><strike></strike>
July 9, 2015
June 23, 2015
June 27, 2015

<tbody>
</tbody>

 

[admiral100]

Hi,

another option

=MID(A1,FIND(" ",A1),3)&"/"&MONTH((LEFT(A1,FIND(" ",A1)-1)&" 0"))&"/"&RIGHT(A1,4)

 

[gaz_chops]

In that case, I think (but cannot test to be sure) that selecting the column and calling up the Text To Columns dialog box (as I instructed in Message #5), but instead of hitting the Finish button right away, select Delimited on the first dialog page and clicking the Next button, unchecking all the checkboxes on the second dialog page and clicking the Next button, then selecting the Date option button and selecting MDY from its drop down box on the third dialog page followed by clicking the Finish button might work..

Produces the same result as AkaTrouble posted in #9.

 

[admiral100]

Just change the order
MONTH then MID then RIGHT

 

[gaz_chops]

Just change the order
MONTH then MID then RIGHT

I was referring to Rick's suggestion of using text to columns.