Convert Text (number and text) into date

[spinelli victor]

05August2011

28April2011

23February2010

16June2011

17October2011

10November2012

05September2012

<colgroup><col></colgroup><tbody>
</tbody>

I have a list of text on this format. How can i tranform it into date. I tried to seperate them but i'm blocked, i don't know how to convert text month non listed into date.

Any ideas ?

 

[Saba Sabaratnam]

Hi

If the date is in the above text format, use the following steps to convert it to date:

Type 1 (one)

Copy it

Multiply the above text dates by it using Multiply under Operation on Paste Special dialog box

Let me know if it works.

Saba

 

[spinelli victor]

Thanks

 

[Peter_SSs]

Another option you could try ..
Select the column -> Data ribbon tab -> Text to Columns -> Finish