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>

 

[gaz_chops]

Welcome to the forum.

Try

=TEXT(MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1)&" "&LEFT(A1,FIND(" ",A1)-1)&" "&RIGHT(A1,4),"dd/mm/yy")

 

[klllmmm]

Thank you very much gaz_chops. It works.

I knew both text function & mid function. but never thought I can make use both together & solve this issue.
What is did all these time is segregate the dates to columns using text to column, replace each month text to corresponding number of the each month one by one using find & replace. Then combine through & function. Then change the format through the pop up message appears.

You made my life easier.

Thank you very much.....<strike></strike>

 

[gaz_chops]

You're welcome, glad it worked.

 

[Rick Rothstein]

You can change your text dates to real dates directly within their existing cells. Select the column with your text dates, call up the Text To Columns dialog box (Data tab) and as soon as the dialog box appears, click the Finish button.

 

[gaz_chops]

You can change your text dates to real dates directly within their existing cells. Select the column with your text dates, call up the Text To Columns dialog box (Data tab) and as soon as the dialog box appears, click the Finish button.

I tried that Rick and it doesn't appear to work.

 

[AkaTrouble]

You can change your text dates to real dates directly within their existing cells. Select the column with your text dates, call up the Text To Columns dialog box (Data tab) and as soon as the dialog box appears, click the Finish button.

that doesn't seem to work for the format of the dates shown as examples

i copied the dates as shown above and did as you advised.

i felt there was a way and had tried all the date format under format cells option to no avail


EDIT

Snap @ gaz_chops

 

[gaz_chops]

I am guessing it will work if you are using US date format but not with UK date format.

 

[AkaTrouble]

I am guessing it will work if you are using US date format but not with UK date format.

i tried stepping through the sequence and selecting date on third screen and selected MDY format it worked for half of above list

July 17, 2015

04/08/2015

23/08/2015

July 21, 2015

July 13, 2015

18/10/2015

July 9, 2015

June 23, 2015

June 27, 2015

<tbody>
</tbody>

but yes put those into UK date format so think you are right it uses system date format and only works correctly if US

 

[Rick Rothstein]

I am guessing it will work if you are using US date format but not with UK date format.

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..